-
RYG Formula linked to Status and Start and End Date
Hi Smartsheet Team, I am looking for help with a formula: I have a column "Schedule Health" that has RYG Balls I am wanting this to change color based on certain criteria from 3 other columns "Status", "Start Date", "End Date". Ball is GREEN if "Start Date" is 7 days from today (ie project has not started yet) Ball is…
-
Is it possible to autofill all cells in a column with a formula in new rows?
Hi, I am using helper columns to overcome what I think is a major missing feature - the inability to use formulas for conditional formatting (for instance, if a date in one field is after a date in another field). The solution proposed elsewhere in the forum is to have a helper column with a formula and then doing the…
-
IF(CHILDREN()) ? - Child inherits parent traits for entire column
I could've sworn I'd seen this but now I can't find it: We have a sheet for incoming project requests. Our general population can request multiple new mkt materials (printed direct mail, email, outlook MSG, etc.) for a campaign in a single 'ticket.' Then our PMO hotseat creates a new child row for each of those unique…
-
Need report that only shows fields that are NOT blank
Hi, new to Smartsheet but enjoying it so far. I'm building a report from multiple sheets that would ideally be a master list of all the rows that do not have a blank cell for one specific text/number column. The values within the column will vary widely but some will be blank, and I do not want to show the rows that are…
-
Select Multiple Values Using IF Formula In MultiSelect Dropdown
Hi Smartsheet Community, Recently I've been working on a column that allows me to assign required approvals based on certain roles (see below). I want to create a formula that can output an role if it's associated contact has been filled in or not. So for the example below, I would like it to output Project Owner AND Man &…
-
Formula based on the date that a certain cell was modified?
I was wondering if it is possible to create a formula that changes one cell to a date when another cell was modified: I have two columns I want affected: 1) Status, 2) Closed Date. When the status is changed to "Closed" (it is a dropdown column), I want the closed date column to input the date that the status was changed…
-
checkbox formula for last 30 days
Hi, I have a date column which lists down all the dates in the year and a checkbox formula. In the checkbox column, I would like to insert a formula that would perform the following function for me: If the date in the date column (row@cell) is in the last 30 days then checkbox.
-
Cross Sheet Formula Limit Error
I'm currently getting an error related to the cross-sheet formula limit. I'm not sure why I'm getting the error. So far I have referenced 6 columns in other sheets with SUMIFS formula. I received the error when I added the 2019 formula below. There are ~17,000 records on the referenced sheet, would that be causing the…
-
Not able to count total of different percentage fields?
I'm trying to get a breakdown of how many of each percentage group we received from this quiz and I've tried totaling from a percentage column as well as when the column is set as a decimal and I just keep getting 0 as a total, only the 100% has worked. Not sure if I'm just overthinking it or what, but here are some…
-
Formatting in Formula Cells
I have two date cells that I have formatted as long dates (May 30, 2018) titled Contract_Begin and Contract_End. I want the formula cell to read contract begin date through contract end date (for ex: May 30, 2024 through August 10, 2024). However, the cell formats to 5/30/24 through 8/10/24. I posted the formula I am using…