-
Formula that checks if a certain date is in a date range and TRUE/FALSE VALUES
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 chart in a dashboard with month counts and sums. I created this report to show what is needed in the formula. Count: Count…
-
Open Sheet in Gantt View
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?
-
Image Header Size for Dashboard
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 the dashboard through the Image widget, it barely spans half the page, and I can't make it bigger. I want to be able to…
-
Different formula for a cell basing on condition
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 = "Story " I need formula for Original "=SUM(CHILDREN())" i tried IF(Type = "Sub-Task" , "=Duration*1440", "=SUM(CHILDREN())") but…
-
R,Y,G and G - Part 2
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 the parent level, I'd like the "current health" (R, Y, G, Gray) to be the color of the highest risk child (or gray if there is…
-
Find Parent that is not blank or row with no children
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 does not give me rows that do not have any children. I need rows that are parents and not blank + rows that do not have…
-
Dropdown (Multi Select) Sheet Column In A Form
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 sheet itself I am able to enter values in addition to those provided in the field's value list. However, when I attempt to…
-
Report based on 3 sheets with the same primary column
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 the informations automatically on the same line. Please, can someone help me? Thanks.
-
Can anyone assist me with VLOOKUP formulas?
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 VLOOKUP formula gives #NO MATCH errors or sometimes gives the same employees information in all the cells. Has anyone else…
-
Error 1012: 'Required object attribute(s) are missing from your request: values.'
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 have seen others post similar issues but with 'cell.value' as the missing attribute. In my case, what is 'values' supposed…
