-
Can we safely use cross-sheet references in column formula?
Hello everyone, I have a fairly large sheet (~5000 rows). I have one column whose value gets changed based on data from another column within the sheet. The source column is a country code column and the column that gets updated displays region based on the country code (EMEA, LATAM, NA, etc.). I decided to create another…
-
Count if formula to include multiple years
Hello, I am attempting to count all the submissions for 2023 and 2024 - my current formula only allows the dashboard to reflect the current year submissions based on my helper column for the year of submission. Does anyone know how to update the formula to count all submissions from 2023 AND 2024? Current equation:…
-
Creating a chart, based on tasks per date
Hi all! Grateful for any help that can be offered. I have sheet that is a simple list of tasks. One row per task, with a created date column. There's other columns such as status, assigned to etc etc. Can someone please help me with creating a chart from this? I want a bar chart which shows number of new tasks per day. The…
-
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…
-
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?
-
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…