I have two sheets that have linked cells. I want to use the workflow to make the tasks from the second sheet disappear if the Status column says complete. Is this possible? I know how to set up a work…
Hello, I am trying to create a widget to display on a dashboard. This widget will give the viewer an immediate idea of where the project is in the project timeline. Ideally, the widget would look like…
Hi I am currently using this formula =SUMIFS([Number of Slides]:[Number of Slides], Done:Done, 0, Status:Status, "Handed to Pathologist") I want to look at the date for the next 30 days. I have a colu…
Hi so I am using this formula =SUMIFS([Number of Slides]:[Number of Slides], Done:Done, 0, Status:Status, "Not Started"). I want to also only filter by a certain date. how do I add that. There is anot…
So this formula works for me. I am trying to add another criteria though and cant figure it out. =SUMIFS([Number of Slides]:[Number of Slides], Done:Done, 0, Status:Status, "Stained") And it works but…
Happy Wednesday! I have been going in circles trying to figure out where this formula is going unparseable. I researched it against other similar (working) formulas in smartsheet and the Formula error…
Hi, I am working on something that requires to sort the Smartsheet based on a column. The type of column is 'TEXT_NUMBER'. 1/0/12 1/0/1 1/0/14 1/0/3 1/0/11 After sorting the smartsheet with the above …
This is the formula I'm using, but I'm getting unparseable: =(SUM([Actual final door count]:[Actual final door count])) / SUM([Inspection & minor repair labor hours]:[Inspection & minor repair labor h…
I know I can run their smartsheet access report but that doesn't give me the information I need. I think the best way to explain what I am looking for is to give an example. I am trying to create dash…