-
Combining IF Statement and IFERROR
I need some help. I have the following 2 statements that work well alone: =IFERROR([# Days Since Last Offer]@row, "Auction") =IF([# Days Since Last Offer]@row >= 180, "Auction") But I need them in the same formula. I want to return the work Auction IF the # days is 180 and IF an error is being generated in the cell.
-
2 SUMIFS NOT equal to 2 variations
Hello, I've tried the below formula but it doesn't work (instead of SUMIFS A AND SUMIFS B), This works: =SUMIFS(pay:pay, [Code a]:[Code a], [Code a]@row, [code b]:[code b], "<>apple") This doesn't work: =SUMIFS(pay:pay, [Code a]:[Code a], [Code a]@row, [code b]:[code b], "<>apple") + SUMIFS(pay:pay, [Code a]:[Code a],…
-
Cell Reference to Other Sheet with Column Formula
Hello Smartsheet Community, I have a question regarding cell linking, while maintaining a column formula! I am trying to reference a certain cell in sheet 'X' back to sheet 'Y' and then create a column formula in sheet 'Y' that allows for automation of information that is being captured in sheet 'X'. Is this possible? I…
-
% Variance between 2 numbers
I am trying to figure out the % variance between 2 numbers ($40,190,187 and $40,279,091) I just need the formula can anyone help?
-
HELP!! Need a formula to count days if the days are in a specific week number
Hello everyone! I hope someone can help me figure this out! I am quite good with formulas but for some reason, this has me stumped completely! I have developed a Time Off Request process for our company. There is a start date and end date. I have columns that return week number based on the date range. Basically I have a…
-
Find and Replace in a selected section?
Hi, can I do a find and replace in a section columns instead of the whole sheet? Thanks
-
Is there a way to get custom color conditional formatting in smartheet?
-
Using IF/AND and blank
Hi, I'm trying to populate a cell with "Verified Lead" (from a drop-down) if Sales & Leads box is checked and Blue Button Request # is not blank. This is what I have but it's not working: =IF(AND(NOT(ISBLANK([Blue Button Request #]@row)), [Sales & Leads]@row, 1), "Verified Lead")) Thanks for your help!
-
Deadline based on Priority dropdown menu
Hello all, I am using SS to process work orders. People fill out a form which has a priority dropdown column with classifications such as urgent, semi urgent, can wait etc... I wanted to see if i could write a formula in the deadline column to calculate a date based on the priority picked. ie- if someone picks urgent, the…
-
COUNTIFS + CONTAINS + OR Formula
Hello - Looking for some assistance on a cross sheet formula. What I'm trying to calculate is how many Level 2 rows display a specific project manager name from a multi-select column type. There are several rows with more than one name. Additionally, I want the formula to count all projects that have High, Medium, or Low…