-
Filter "is one of" drop down lists
Is there a way to clean up the drop down list on "is one of" filters? They still contain items that have been totally deleted from the column being filtered. This is very confusing to users. Thanks
-
Customizing Reminder message
I have a sheet where I log our employees training. I set up a calculated date column where I add 60 days to their training renewal date. I want to setup a reminder telling me that such employee need to renew his training within the next 60 days. How can I customize the reminder message so it's shows me this employee and…
-
Magazine Project Sheet?
My department manages the production of a quarterly magazine and uses SS for the editorial/content management process. Here is the sheet we currently use: https://publish.smartsheet.com/c95e42926fad4be7ae3463eaf2b228da I'm wondering if this seems like the best process, or if there's a simpler solution to a project that…
-
Conditionally move rows with Zapier and a check box
Hello all, I would like to automate my time sheet approvals. I use the professional plan with zapier, which does allow multiple steps. I am trying to conditionally move a row when a check box is checked in the "approved" column. However, I cant figure out how to enter the selection criteria in the "custom" value portion of…
-
Linking pages
Hey Guys, i am looking for a way to have vital data show up from one sheet onto another. I am using 6 sheets to keep track of project data. Each individual line in the sheets has all of the data for one project. In this line is a check box that states "Ops Scheduled". I need a way to have projects lines that do not have…
-
time sheets form
I want to create a form that I can e mail the link to my employees on site weekly to collect hours. Ideally include Employee Name Start Date of week Day Site from a drop down list Hours at site Options two sites per day. Note at bottom to advise on holiday , illness Thanks in advance Grant
-
Using a checkbox and an IF statement to perform a function
I have been using Smartsheet to track production and perform P+L on projects at a construction company. I am attempting to have the sheet calculate our percent profit on a project only if our GPM Report checkbox is checked for the job. Ideally I would like to incorporate this into some other calculations as well but I will…
-
Alerts & Actions
I am trying to ultimately set up my sheet to automatically send out Update Request 3 days (or whatever I set) within the "Bid Date" loaded into the sheet. It would be ideal if this update request would be emailed to the contact in "Sales Rep" column and copy (cc) me in the emailed Update Request for all of them. I was told…
-
greater than or equals to
i need to activate a check box based on the following condition. if date cell A is less than or equal to Todays date and cell b and greater than or equal to todays date then check box. how do i write this please as i can get the formula to work all but the equals to bit. ta blair
-
IF WITH 2 CRITERIA
I'm looking to make a formula that will do the following: search all instances in Column2 for "A" IF subsequent Column3 has a value of "YES"....if all "A"s = "YES" than return a value of "YES" otherwise "NO" I included an image that hopefully clarifies this a little more. in the image I show 3 "A"s in Column2, 2=YES and…