-
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…
-
Formula to calculate future annual date after initial maturity date has expired
I need to create a new column date in the future on an annual basis when the initial maturity date has expired. Below are the 3 columns I use to determine the initial contract end date based on effective date and the term. After the initial term the contracts then renew on an annual basis. Every contract period end date…
-
New Functions Feature Request
"ROW" - used to reference the sheet row number that can be referenced in other formulas. Something like '=ROW@row' 'PREDECESSORS' = similar to current 'SUCCESSORS' function but returns the row references for predecessor tasks in dependency enabled project sheets. '
