-
Is my alert too redundant?
Did I set up this alert to be too specific? I want to have an individual notified when a row to which they are assigned to has the status change to "In Progress". I'm trying to test it now but have doubts about the "In a row where any status is In Progress" line I included. The red in the picture is where my colleague's…
-
Indent not working
For some reason my indent and outdent is greyed out and unavailable. I can't figure out what I am doing wrong. Any ideas is very much appreciated.
-
Need a Column Property type that is "clock" or "time of day"
As an event management company, we have on-site event schedules that require a "start" and "end" time column. Those columns need to reflect the time of day and currently we have to create a whole drop down list of 24 hours to choose from for those columns. Am I missing it if it already exists? Or, if not, it would be great…
-
Linking upcoming dates from sub sheet to the master sheet
My company has a master sheet connected to all the different project sheets. Is it possible to have the next due dates listed in the project sheets automated to update on the master sheet? Currently, we're just doing this manually and it is a pain for us to constantly look at the sheets.
-
Calculating Number of Items in a Month based on System Generated date field
Hello all - Needing help with a formula to calculate how many requests are submitted via a webform for each month. 2 questions related to this: 1. Can a formula pull just the month from a System Generated cell: Created by (Date)? 2. Where are errors in this formula: =COUNTIF({Date Submitted}, MONTH(@cell) = 1) 'Date…
-
cannot download attached files
The sheet that I have shared with a colleague has attached mp4 files but he cannot download them. The download option is grayed-out. His permissions are set to: Editor-can share. When he clicks to download, it asks him to log in with his Google account (as shown in the screenshot). Does anyone know how I can change…
-
Regional User Group
My company and I are new to smartsheets and would like to form a regional users group. We are based in Lexington and would love to be in touch with other users in Kentucky and surrounding states. It would be helpful to talk and work out problems together as well as see how others are leveraging the capabilities. Thanks!
-
Status Change if Column Checked
Hi everyone, I need some help with a formula that just doesn't want to work for me. Currently my status column changes according to the {Proof Approval - Kim} column. It works fine (formula shown below) Now I want to add on to this formula so, if the column {Out For Approval} is checked, I want the status to change from…
-
Document review/approval tracking
Interested to hear if anyone has setup a process in Smartsheet to track document review and approval. SOWs and Cost sheets need to be reviewed and approved by multiple people prior to being reviewed by the customer. I'd like to embed this process into an existing customer tracking smartsheet if I can but am undecided on…
-
T-shirt size icons for visual icons?
Would love to have S/M/L T-shirt icons to visually look at sizing. This would be helpful as a project manager and on a scrum team