-
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
-
Printing row with selected columns only
Is it possible to print out a row without printing all of the columns? I have a task scheduling and tracking sheet from which i would like to print a task (row) without including pricing information included in one of the columns. TY
-
Counting Check boxes when Checked
Hello, I would like to find a way for a way to count the check boxes when they are checked. Ideally, I would like formula that allows me to know what date it was checked. I'm not sure if the modified data column can do this because I do not have sufficient data at the moment. Another solution I'm thinking is possible is if…
-
Count "New Entries based on a date" to a dashboard
I am adding new entries to a sheet daily. I need to know on a given date how many entries were added to the sheet. I need to be able to adjust this daily. I have created something on a google doc that works very well but I can't seem to duplicate it in smartsheets. My goal is to have this count reflect on my sheet…
