-
Surfacing Text from one sheet to another
Is there a way to surface text from one sheet to another if a checkbox is checked on the source sheet? I have a sheet with a list of meeting participants and checkbox columns for each of the meetings associated with the program. Some people are in all of the meetings, and some are only in 1 or 2. I'd like to know if there…
-
Assistance Needed with Formula to Identify Late Tasks
I have a Helper Column that I've created in order to tally Late Tasks based on entries in other fields. I want the Late Task column to be populated with 1 if the following conditions are met: [Open Task]# = 1 and [Due Date]# is less than Today. I tried the following formula and receive #INVALID OPERATION when the Open Task…
-
Join columns, not side by side, and skip columns with no info
I am looking to join multiple columns using a "-" as deliminator and I dont have the columns side by side to select range and use Join function. I also want it to skip columns that are blank. Also - I notice in Smartsheet i have to use date format 10/15/2020 is there a way to change it to 10-15-20 (I use "-" as separator…
-
Formula or Rules to AutoPopulate Columns in Sheet
I have a master data sheet where a team of 30+ people will be adding 2021 data and creating our annual plan. To make it easier for them to complete the sheet, I wanted to have the ability to autopopulate certain columns based on their answer from a drop down choice in an earlier column. As an example: 1) If they select…
-
Looking to create a formula to count number of tasks
On the "Corporate Legal" row the formula in the "0 of 8" is the following: =COUNTIF(CHILDREN(), 1) + " of " + COUNT(CHILDREN()) I want to create a Parent Count for all tasks. There are other sections with the same setup. I want the parent section (the cell with a blue border) to count all number of tasks. So if I have "0…
-
How do I use @row in an IF formula when I am referencing many columns for 1 response?
I created a plan with 8 goals, each goal has their own objectives (range from 3-11 objectives each goal, and each objective has their own strategies (range from 3-12 strategies each objective). I want to reference any one of the 42 columns I created for the form logic so drop downs would reflect in the objective or…
-
How to have a formula reference a blank report?
(FYI I do not have summary sheet access) I have a sheet that has a list of open Job opportunities. Of course sometimes that sheet is blank because there are no openings. I created a second sheet for metrics that I could use to put a counter-widget in my dashboard. That is, in my dashboard there would be a metric widget…
-
How to change my status column when Completed column is not blank
Hi everyone - I am new to smartsheet and am trying to figure out a formula for the following scenario: When Completed Date is not blank, make status Complete, otherwise I want to leave whatever value is there (the value will either be In Progress or On Hold). Help greatly appreciated.
-
RGB Formula
I am wanting my formula to turn yellow if the end date is between 3 and days away. How would I make that work? IF(AND(Status@row = "In Progress", [End Date]@row > TODAY(-10), [End Date]@row < =TODAY(3))
-
Count IFS
I am trying to build a formula that will count the number first based one the COE name, then to give a number on each disposition status. I thought it would be something like: =COUNTIF({Policy Project Status Report Range 3}, "Global Rewards"),({Policy Project Status Report Range 1}, "Keep/Enterprise") OR…
