-
Automating RYG balls based on completed dates in parent row OR children rows
Hi all, I have a sheet with parent rows where the status column is updated with a RYG ball based on the completion date and due date of the row: =IF(ISBLANK([Due Date]108), "", IF(ISDATE([Completed Date]108), "Green", IF(TODAY() - [Due Date]108 > 0, "Red", IF(TODAY() - [Due Date]108 > -7, "Yellow")))) The children below…
-
Incorporate two data sets in one if/sum statement.
I have one column where I want to sum the total amount of days of work, however, I want the sum column to be dynamic based on the %Complete column if the percentage is <100%. I want the Sum column to show a total value anytime the % Complete is less than 100%.
-
Sights Dashboard Feedback from Power User
Hi there, not sure where to put in my feedback for Sights but I think it's a great tool but has the potential to really be so much more powerful for business users. I feel like I get stopped at ideas due to lack of features. Here are some ideas I hope you can add: - Export to PDF: we use the dashboard as sort of a…
-
Any way to change the "predecessor"'s values via the API?
I know that such functionality is not supported, but I was wondering if maybe there are work-around. I am creating an script that bulk edits various sheets by starting from one sheet (useful if you want to synchronize multiple sheets) - https://github.com/EffEPi/smartsheet_bulk_edit The problem that I am having is that…
-
Linking cells based on matching criteria
I have two sheets, both sheets have a row of column IDs, I would like to dynamically match the column ID from one sheet to the other sheet and then update a row. Similar to the new Lookup fucntion that was recently released but across two sheets. Has anyone developed a solution for this. My only option is to manually link…
-
Row & Update Requests - see message comment?
I have a sheet set up to track drafting requests. i.e. A staff member submits a request to create or update a site map. The persons in our drafting department get notified and one of them will start on the task. In trying to keep all communications within SS (and not email discussions), I've instructed the drafting…
-
Using formula =MAX(children())
Dears: I'm talking about one Date formated column. When my Parent cell has that formula and I have 4 children's (2 filled and 2 unfilled) the formula returns the MAX value between the 2 filled cells. I want for my Parent the MAX from all four childrens. I need to return the MAX value only when the 4 childrens are filled.…
-
Advanced User Training
Does anyone know if Smartsheet has ever had (or is planning) advanced user training available, similar to the Smartsheet Academy you can attend in person? or a User's Conference? It would be much easier to sit in a room with other advanced users and share ideas in person vs. on the web.
-
Card View Vertical Drag changes value
I love the new card view but in each vertical lane I'd like it to organize by the priority value. It would be great to have it automatically set the priority 1 higher than the card I just drug it above. And it would be great if it put it in order of the Priority Field if I edit them directly.
-
IT Employee Change Documentation
Good morning everyone, I'm exploring new options to replace out existing, out-dated InfoPath form for employee IT changes in our organization. Right now we get an XML file sent to our helpdesk, financial staff, and office services, so we'd like to be to emulate that functionality, just with a better output file that our…
