-
Workaround to override column formula for dates?
Hi there, I have a sheet with 8,000 rows. In the sheet, each row has a task, task start date and task end date. When someone adds a start date to the first task, the rest of the dates are calculated with a formula, based on a lookup table that has values for how long each task takes. If I have 10 tasks, I want the formula…
-
Is there a Way to Emulate SUMPRODUCT In Smartsheet With a Cross Sheet Reference?
Hi all! I am trying to create a SUMPRODUCT in Smartsheet, however when I do I receive the "INVALID OPERATION" error. This is how I was trying to go about it; I created a helper column where I would multiply both A x B, then I was simply going to sum up all the products. The issue I'm encountering is with the first part. I…
-
Countifs to Find Duplicates
I am trying to find if there are multiple requests for a bucket truck within a single day. I am getting an incorrect argument set when I try this formula, but I cannot figure out what is wrong with it. =COUNTIFS([Date Resource(s) Needed]:[Date Resource(s) Needed], [Date Resource(s) Needed]@row, [Bucket Type]@row, "55'…
-
Formula Help
Hi, I have this formula that pulls from the values below (see screenshot) but the formula says #NO MATCH when no stage is started, then again once all stages are complete. Can someone help me with a formula that will give another value other than #NO MATCH. It should say "New Project" before the stages start and "Project…
-
Give same value to parents, children, and grandchildren
How can I make parents, children, and grandchildren show the same value for "Project Name" regardless of hierarchy level? I am importing some of the information in the sheet from the database and the children/grandchildren are subtasks that need to be labelled with the project name. The solutions I have tried so far have…
-
INDEXM() function to pull nth value from a multiselect dropdown.
After posting a laundry list of what I believe are simple ideas that I thought had already been requested, it was suggested that I post them individually on this idea board. While I think this idea is out there, I am unable to find it. My apologies if this is a repeat: Function to pull Nth value from a multiselect field.…
-
COUNTIFS formula not calculating correctly in 3 of 4 columns- I'm at a loss
What is wrong with my formula? I need it to return the number of times it finds a certain answer from a drop down list for a specific facility between 2 dates. The dates we are searching are from the first of the current month through yesterday. Ex. if it's March 13, 2024, I'm looking for data between March 1, 2024-March…
-
Formula to generate date 1 year from today?
I am trying to figure out a formula that will generate a date that is 1 year from today. For example, if we have a contract that requires 12 months of notice to cancel, and I have a column to track the Earliest Possible Termination Date, I want that column to tell me the date that is 1 year out, or 365 days after today.
-
Symbols for Multiple Columns or Adding Conditional Formating
Hi, Is there a way smartsheet can make it easier to apply conditional fomulas on multiple rows that meet the "N" = red and "Y" = green, rather than having only a format that can let me select multiple columns to the same color when 1 column has a "N" and setting a new rule each time I want to have "N" be red in a different…
-
Symbols on all Columns
Hi everyone, How can I apply symbols to all columns without have to individually right click on column to pick a symbol? Thank you!
