-
Helper Column Parents and Tasks with 0 Children
I am using this formula in a helper column to identify which of my rows are "parents" however I would also like to Identify Rows that are Projects or also "Parents", but have 0 children " so that I can tag in conditional formatting along with my Parent Rows that have children. Can you help me create a formula that can do…
-
How do i get count of values against specific names
I have three columns . What i need is a formula to get details - If range responsible person is selected, what is the sum of target for each person seperately and in a similar way on the actual column what is the sum of actual by each person. The result i am look for should look like the one below. responsible person…
-
Creating a new Report based on a single Sheet
I create Reports frequently and am comfortable with the process. What I'm wondering is if there is an easy way to create a Report from within a Sheet that is based on that same Sheet? I guess I'm looking for an option in the File menu that says Create a Report from this Sheet vs. starting a new Report and then selecting…
-
Ensure a cell value is unique OR if already used, match the previously used value
I'm completely new to Smartsheet so I may be overcomplicating this, or going about it the wrong way. I want to ensure the value entered into a field is either unique within the column, or if it has been used before, then I want to to be exactly the same as a previously entered value. The use case is: I have a Smartsheet to…
-
Showing multiple true checkboxes as joined or concatenated text in another column
I have a volunteer submission form which has about 10 columns that exist as just checkboxes on/off - each of these relate to a conference work area and volunteers often select multiple. To easily view the data for a single person/row without tons of scrolling and looking up and down at column titles, I want to aggregate…
-
Financials: projected, actuals and variance
Hi! Very new to smartsheet and looking for any preset reports for tracking 3-4 year project financials, specifically projected spend, actuals, and variance. Does smartsheet have this type of reporting? Thanks!
-
Report with multiple tasks as ("what") conditions
How do I create a report with multiple tasks (in my primary column) as conditions? E.g. I wanted to display sheets in a report where Task 3 = Yes AND Task 5 = No.
-
Link comment
Bonjour à vous I would like to know if it is possible, to have a quick access of the good line in smarsheet when you link a colleague and you leave a comment with the @ and they open it in a email ? All the time when they open it, they are redirect in the master sheet... Merci
-
Cancel Scheduled Backup
Does anybody know how to cancel scheduled backups?
-
Building custom actions
I need to continue some training in setting up actions from one sheet to another. I can use the pro-desk to set up a 30 minute training session but can't remember how to get the code to type in for a new request. Thanks, Dennis
