-
Tracking variances between baseline and actual dates
Hello, I have copied a plan into Smartsheet from MS Project and have followed the instructions in https://www.smartsheet.com/blog/smartsheet-tips-tracking-baseline-schedule-variance to set up a means of tracking the variance between baseline and actual start and end dates. However the message # Invalid Data Type appears in…
-
Feedback Submitter Count
I have created a Feedback intake form and a Dashboard. In the Dashboard I would like to chart total count of submissions by each submitter name. I do not have a list of those who will submit but I know they will submit multiple entries. So I want to be able to count each of their respective entries. Lets say John submits…
-
Create RYG Balls for Children
I've spent hours attempting to display RYB Balls for three different drop-down status. "Not Started" "Pending" "Signed" The goal is to have a "Red ball" display in the Not Started Column for the drop down "Not started" in the Quote status children. The formula I'm attempting to adjust - =COUNT(CHILDREN([Quote Status]2 =…
-
Enhancement Request: Filters to include and / or functionality
I would like to request the ability to customize filters by adding specific conditions to each row. The filters currently have an option to show rows that match all conditions or an option to show rows that match at least one condition. Because we share our SmartSheets with multiple teams, I would like the ability to add…
-
Submitting a row to two sheets broken by SDK updates
We have a form on our site that adds a row to two sheets in Smartsheet. This broke in June at which time the form added a row to the first sheet, but failed in the API call to Smartsheet in adding a row to the second sheet. Example Code that submitted to the first sheet (this was not affected): protected void…
-
Formula to display Red Flags
I am attempting to have a RED Flag populate in the "Risk" Column for cells where the "Available Space" is less than 10. Kindly when answering, please complete the entire formula from start to end as from research I tend to get bits and pieces as seen in my screenshot. Thanks,
-
Update VIA API not showing updates
Hello There Super Noob to Smartsheet APIs. I am updating smartsheet, with Powershell, a Test Sheet sending simple sample data. It shows that I have added multiple row, in the test sheet, but it isn't showing the data even if I refresh the sheet. I have no Idea whats going on.
-
Using SUMIF to provide value of orders from this week only
Hi, I am trying to get a formula to sum the total value of orders invoiced this week. The formula i have tried is below, but returns '0' as the value. =SUMIF({Completion Date}, {Completion Date} = WEEKNUMBER(TODAY()), {Order Value}) The sheet references are to single columns titled 'Completion Date' and 'Order Value'…
-
Smartsheet limitations when collaborating with multiple teams
I've been using Smartsheet for a few years now, but recently we have been rolling it out for more serious applications involving collaboration between multiple teams, including external teams and we seem to have come accross a fundamental limitation of Smartsheets, that being the permissions model. For a platform whose…
-
Selectable Drop Down Menus For Web Forms
Is it possible to create drop down menus within web forms? I am looking for a way to have limited selections for each question which does not allow the submitter to create discrepancies. Thanks!