Sumoling123456Q: Hi, 1) Why you do not have live chat support?!
Will you add?
2) I have sent several messages to the form and no reply yet - after so many hours.
3) There are many bugs like showing wrong data or corrupted data from google sheets like column names etc. Will you fix ASAP these?!
4) The documentation for python is not really helpful -- will give more concrete examples about formulas and syntax?! It it quite unclear and I know python.
5) Your formulas do not work for non English column names like Greek, German?!
6) How to insert a formula on single cell?!
7) How to sum the values of a column to a cell AND/OR to a new column/table?
Best
Anais-Grist
May 15, 2024A: Hello! đ
1. We'll definitely consider adding live chat support once we're sure we can meet the expectations of a live chat. Currently, our team is small and we'd hate to disappoint users who expect immediate responses in live chat.
2. Sorry about the wait! You may find the forum moves a little quicker. https://community.getgrist.com/
3. I would need more information about the document you are trying to import to be more helpful. For example, some merged cells and formulas could potentially be causing some issues. Note that formulas do not import into Grist.
4. We're working on a formula cheat sheet. In the meantime, you can ask for formula support in our forum here: https://community.getgrist.com/c/ask-for-help/formulas/11
5. Columns have labels which you see, and those support any language. Columns also have column IDs used in formulas and API, which at the moment have to use English characters. Column IDs are generated automatically from labels.
If you wish, you can set column IDs separately. In the creator panel on the right, in the column menu, youâll see the column label, and below that, the column ID. Click the link icon to enable editing of the column id.
We're currently working on permitting international characters in column ids.
6. Grist formulas are always on a whole column. If you need a formula that does one thing for certain rows, and a different thing for other rows, the recommended approach is to include the conditions in the formula itself. This is described here with an example: https://support.getgrist.com/formulas/#varying-formula-by-row . It takes a little getting used to to adapt from the spreadsheet mindset to the database mindset -- it certainly did for me! đ But hopefully you'll have an experience similar to mine and find that the database is much more powerful.
7. Summary tables and summary formulas (https://support.getgrist.com/summary-tables/) make simple sums easy in Grist.
We have a video tutorial available here: https://support.getgrist.com/examples/2021-06-timesheets/
You may also use formulas to add cells from two different tables into a third table. There's a great discussion about this in our forum. https://community.getgrist.com/t/how-do-i-calculate-sums-from-multiple-tables-to-a-widget/81/8