Formulas
Discussion List
- Excel has leapfrogged Smartsheet in terms of ability to utilize data set, naming manager, dynamic data slicing, Dynamic Table formatting in excel sheets and new formula types LET used with Naming Once…
- 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"…
- 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 an…
- 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, outloo…
- 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 …
- 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…
- 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 …
- 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: I…
- 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 …
- 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…
