-
% 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.…
-
index and match not working right!
hello everyone, for the life of me i cant get the index and match to give me the data i want to see and i know i have missed something simple. my main sheet is "Master NSW Schedule" (MNS) i have a secondary sheet meant for other users "DETAILING SCHEDULE V2.0"(DSV2.0) this is to hide certain information from them but the…
-
Urgently need help with a formula!
I have a sheet used to maintain a list of projects, I will call it "Master Project List" and I have a second sheet that the team uses for scheduling which I will call "Scheduler". Team members use a form to enter their planned hours on a project into the Scheduler which includes the project number and the task name. Each…
