-
Am unable to retrieve Dates from one smartsheet to other
While am trying to use vlookup function the limitation threshold is an error prompt. I tried to use Collect and Index Collect function however they are giving me error prompts as # Date Expected and Incorrect Value
-
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.