-
Project Approval Received / Master Project Sheet Populated
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, column values for new projects to be copied over to a master sheet, which includes additional columns for project charter and…
-
Alternating Row Colors
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 anywhere in the UI. Thanks for your help.
-
Sharing a Folder in a workspace
How can I share a folder with specific people in a workspace while limiting them from seeing other folders in the same workspace?
-
Health Check Formula Error
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, spelling, quotation marks and I can validate every logic function except the first =IF statement. Thought it was a ")" issue, but…
-
Referencing a current period on a "Metrics" Page
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 CURRENT month fields without including all the previous months rolling. How do we make it automated so it's just the current…
-
Trying to combine an IF statement and an OR statement and NOT(ISBLANK)
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 can look at each of my statements and see what I am missing. I think I am on the right track but I keep on getting an Error…
-
Approval process form with custom comment field. NOT THE GENERAL COMMENT FIELD.
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 Approver for example. Sure he can insert a comment in the general comment field but i would like to have a field only for…
-
Report not Matching Formula Issue
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 be printed for each workshop: You will see on here that there is: * 3x for the FASTRACK Workshop * 10x for the Van Workshop *…
-
Pull Data from Master sheet to another sheet
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. I need a separate sheet so I can use it for widget in my dashboard. I don't want to filter or sort the main master vendor…
-
Forms
Is there any way at this time to add a photo into the title area of a form? IE on the one beneath where it says, "SmartSheet Popping Plate" Would there be any way to put a photo there of say a company logo?