-
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…
-
Multi-automation approval request
I have a form that when submitted should trigger an approval workflow. The approval email is sent out when triggered, but after the approval has been made the submitter from the form does not receive an email. See attached workflow. The Sponsor Email column is where the email address lies to be contacted once approval or…