Hello! I need help on a formula that outputs a count and a sum since we are unable to build formulas from a gantt chart. This is the formula page I am using in order to build a gantt chart with a bar …
My sheet is opening in grid view. I can change it to Gantt once I am in the sheet but how do I change the settings so that it just automatically opens in Gantt view?
I'm trying to include a header image for each of my client's dashboards. I had my content person create an image that spanned across my browser, that was saved as a png file. However, when I add it to…
Hi All, How can i apply different formula basing on cell value? For instance i have a columns Type, Duration, Original If type = "Sub-Task" I need formula for Original "= Duration*1440" If type = "Sto…
Hey @Paul Newcome / @Andrée Starå , Well if you dont mind helping, i'll ask another question :-) Started a new thread for others that might want to see it as a separate request. . In a nutshell, at th…
How do I find whether a cell is a parent and not blank? I have tried =IF(AND(NOT(ISBLANK(Description@row)), COUNT(CHILDREN(Description@row)) > 0), 1, 0) which gives me the parent and not blank, but it…
I have a Smartsheet column configured as a Dropdown (Multi Select) column type and do not have the checkbox ticked for "restrict to dropdown values only". While entering data in the column within the …
Hi everyone, i want to make a report based with 3 sheets (Financial informations, planning informations, others informations) which have a common reference in their primary column. I want to have all …
I have an employee register sheet and another sheet. I would like to use the VLOOKUP function to populate some of my employee information in my other sheet when I select my employees' names. The VLOOK…
I'm having difficulties with the AddRows method in Smartsheet's C# SDK. I have been getting the error code 1012 with the message 'Required object attribute(s) are missing from your request: values." I…