-
Can I sum two cells together and then clear the contents of one cell without changing new total?
I have two cells that I would like to sum together based on a check box. When Order Received is checked, Quantity Delivered is then sent into my total inventory in row 1. I would then like to clear all of the contents of row 2 through an automation, because that order is complete and done with, without changing my new…
-
Copy Row automation brings original sheet 'Created date' instead of showing date it was moved
Please help, I have a helper sheet that I am using to capture time stamps of when a row goes to different statuses (ex: capture time stamp when request status changes from: In Review, Pending Response, and Completed). To do that I set up a copy row automation that triggers when those statuses change. Then it copies the row…
-
How to use Smartsheet for event planning
Hey there, I'm working with a group to start using Smartsheet for event planning and looking for recommendations on how to set something up for a workback from the event date for task tracking. Just looking to see how other people set up their sheets so I can potentially streamline what I'm doing. Thanks!
-
Copy References from one sheet to another, individual or bulk. + add multiple references
How do I copy an existing reference from one of my sheet to another existing sheet? How do I add multiple references without re opening the reference manager? It always closes.
-
Cell Linking to Sheet Summary Field
I like the function of the Sheet Summary but what I am curious on is how would one link a cell to one of those Values. Also how do we see the historic values for these fields?
-
How to use COUNTIF on a Smartsheet Report
Hello - I have a report that manages all past due, in progress, and upcoming tasks sorted by team member. I am trying to use the COUNTIF formula on my Metric Sheet to count the number of past due tasks by team member in the report. My goal is to use my Metric Sheet to gather the number of past due tasks by team member and…
-
Error Code 4002 - Server timeout exceeded. Request has failed.
Does anyone have experience dealing with Error Code 4002 (Server timeout exceeded. Request has failed.), and has any ideas on how to handle it. It seems to come up for me when i am trying to update larger sheets Thank you
-
The order in the form does not match with the order in the sheet
Hi group, I created a survey in Smartsheet and I see that the order of questions in the form does not match with the order of columns in the sheet. This may be because some questions were added later into the form and inserted between existing questions. The order in the form is the correct one. Do you know how to easily…
-
Project Management
We have 4 employees that receive daily projects assigned to them. To avoid having the employees viewing their co-workers daily schedule by sharing the project management sheet and doing a filter so they only view their daily projects but can also turn off the filter as they please to see the complete project management…
