Failry new to Smartsheet, I can do this so easily in Excel, but not in Smartsheet. I'm basically trying to add an amount requested based on whether or not the request was approved. The approval is a d…
I'm trying to setup an intake process where a new project is submitted through a form and appears within a project intake sheet for review/approval/denial. If approved, I'd like certain, if not all, c…
Hello, I am trying to format my entire sheet with colored rows that alternate. The Excel formula that perfomrms this is : =MOD(ROW(),2)=0 This would be an awesome feature but I can't seem to fiund any…
I am attempting to create a Red, Yellow, Green, Blue health check based on a Status Column and Planned and Actual Dates. I continue to get an #UNPARSABLE error message on below. I have checked, spelli…
I want to create a monthly metrics page. When referencing the Database, which is an account list for our employees rolling monthly (going down) how do we make the metrics correspond only to the CURREN…
I am trying to utilize an IF statement and an OR statement. I am able to successfully make each statement work independently but when I put them together it doesn't work for me. I am hoping someone ca…
Good Morning all, I established an approval workflow with a loop by using this: https://community.smartsheet.com/discussion/how-loop-through-workflow However, i would like to track the comments of the…
Hi, I have created a report to use on a dashboard for showing the number of job cards to print for our workshop. The report is shown below, and you can see that there are different amount of jobs to b…
Hello, I have a master vendor list sheet that contains a checkbox column for vendor type. I would like to create a new sheet that pulls over just the vendors that have the vendor type column checked. …