-
Control Center: Adding new sheet to provisioned projects using Optional Templates, broken formulas
I have a new sheet I want to add to an already provisioned project in Control Center but all the formulas return broken. I have created the sheet in the blueprint and have saved it as an optional template. This optional sheet is linked to other sheets in the blueprint (it is a summary of data linked to source data - for…
-
How do I create a predictive balance formula?
I'm not sure if this is even valid/possible, but I'm trying to create an accounting schedule which foresees upcoming payments and reflects the balance after the transaction. This image is a practice sheet with fictional values. In theory, I'd want the formula in Balance to always take the previous balance and add it to the…
-
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!