-
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…
-
List of date formula I have used repeatedly
Doing this so I have an ongoing list of functioning optimized formulas , keeping it in the community in case it helps someone else. Please feel free to comment with your own, but I'm keeping the most basic of the formulas out of this. Below are just some of the ones that I thought of now, i'll comment more as I use them.…