Hello all, I was setting up a Workflow to trigger based on a condition at a certain time of day. It did not work, which is fine it was a test, but now in order to run that same test again, I have to m…
Hello, I would like some help in designing a Master Project List, and a Master Project Executive Summary Dashboard. We have a Roadmap that contains each functional area's main projects/initiatives. Is…
Hello I am trying to do cell linking from when the information is entered in from a form rather than directly onto the sheet itself. When I do this it adds the information onto the sheet however it mo…
Hello! What is the default view for a unlicensed user when they open a sheet? (In regards to collapsed and expanded rows) Is it the same as the last way they viewed it, or how the last user had viewed…
HI There, I feel this should be easy to figure out but i cant seem to! PLEASE HELP?! I have a column called "STATUS" , I have a drop down menu with the following under Status STAUS On Hold In Progress…
Hi, I am using status circles for a high level status report. Is it possible to automate the 'Overall' Status Circle based on the colors in the other measures (budget, timeline, scope, KPIs, value). F…
Hello: I have 2 quick questions regarding how to best automate/populate dates for project management timelines. Is there a feature (or formula) within Smartsheets that allows you to specify if a task …
Need help with a formula, 3 conditions- 1) Recognize first 3 digits of "ticket number" (EX: "LEG", "ONB", "REV") 2) Recognize when a task is past due 3) Status not "Complete" or "Not Applicable" What …
I'm trying to see if formulas can reference reports or just root SS. I ran a report for all late tasks assigned to all people in a department. I then wanted to use a COUNTIF formula that would sum up …