-
Sum of expenses of child rows in a formula row
Hi I have a sheet wherein a column contains all the expenses that is basically generated from the sum of other cells in the same row. This row is indented and I wanted to know if I could have the total of this in the parent of this row. Like the way it could be done in a pivot table. The formula in the column is applied as…
-
How to implement default highlight color in to field name
Hello, At present Smartsheet providing highlight changes for recent updates. Is it possible to add a column/field to indicate the recent changes col name in that field.? For example I want to see all the recent changes for the past 2 days in the new column/field it will show this particular row Col-B and Col-D was updated…
-
Nested CountIFS
Hello, I am stumped! I am trying to raise a flag when one cell is blank and 2 other cells match another row. In the example below, the first 2 rows should not be flagged because on is G8 and one is G9 in the Core Program column. The yellow rows should be flagged because none have a deletion date and the Core…
-
If/Then type formula
I have three percentages that are fed in a sheet summary. I can write this formula in the same sheet summary so there is no reason for cross sheet references. I need to write a formula that calculates the median of the three percentages. The only issue is that some of the percentages based upon the goals are beyond 100%.…
-
Employee Pulse Survey Template Set Formula Question
Hello I downloaded the template set for the employee pulse survey when I customized it, the formula to score the questions got erased. Does anyone have the the formula for the helper columns to assign a number next to the survey result? For example neutral should show 3 in the locked column. Thank you!
-
How to change first week number from Jan 1 to July 3 ?
How to change first week number from Jan 1 to July 3 ?
-
#Unparseable error, please help
Hi, sorry to bother, because I know this can be a very dumb question but I have tried all the ways with no luck. I keep getting this error and I don't know where is the error. I want to sum a column called "2022OpEx" only if the sum of other 2 columns ("CarryOverAmnt2021" and "2022CapEx") are equal or higher than 250,000.…
-
Last update Formula (Sheet Summary)
I need to make a formula that identifies the last modified date on my sheet
-
Count Ifs with multi-select
Hello I'm trying to do a count if with a multi-select column and am using the find formula. It is referencing another sheet. can you please let me know if I have any errors here? I get #Invalid Data Type.
-
Automated Move Rows won't move anything
I have an automation set to run whenever a "Status" row changed (or row is added) with a condition: "Where Status Contains 'Out of Service'". It's set to alert me, then move rows. It alerts me just fine, but won't move any rows. Using the row options to move the rows works with ease, and no error messages ever appear. My…