-
Rounding up to the nearest even number
Hi. How can I round up the result of a formula to the nearest even number? IOW, how can I convert the EVEN function in excel to Smartsheet?
-
Index/Match formula?
Hi! I'm trying to create a formula on the Sheet Summary that allows me, based on the Sprint number, to retrieve Start Date and End Date. I've tried to use =INDEX(([Start Date]:[Start Date]), MATCH([Actual Sprint]#, [Sprint #]:[Sprint #])) but it's giving a No Match error.
-
How do I create a Index/Match formula w/ a condition across sheets?
I have a sheet with a bunch of site location data. This sheet includes a check box column showing if the site is Open (Checked = Open). I have another Project sheet where I want to pull in only the OPEN Sites and populate 3 columns from the Location data (Site Name, Region, & Size). I am having a hard time finding a…
-
Project Manager Pay based on 2 different rates
I am trying to figure out the best way to calculate monthly Project billing based on 2 different pay rates from 2 Project Managers. The Project Managers are asked to enter their time for each Project monthly as a % of their total time spent. I have another column that auto calculates that Month's Bill Amount based on that…
-
Calculating 180 days from specific Date column
Hi, I am trying to calculate 180 days from a date column titled "Hire Date". What does that formula look like? I have tried: =[Source Data Cell] + [Desired Number of Calendar Days] =[Hire Date] + [180] =[Hire Date] + [180 Days] None of those work :/
-
How to pull a number from previous row into secondary column matching using a row identifier (name)
Above is the sheet I am working with. I am keeping track of a weekly score for each student and want to try and pull previous weeks scores into the current week row so I can track scores over the past month for a specific student. Currently the formula I am using to pull the previous week score into the column 'LastWk' is…
-
I need with an if then type of formula please!
Still new to Smartsheet formulas. For specific rows in my Smartsheet; If column A has any date at all in it, then I want to populate column B with the text "Completed". Thanks!
-
formula
Hi Experts, I have the following table and I would like to show in column "Rounds" a number. How many rounds we have ordered the article for this stage. I'm looking for a formula which checks the same article e.g. AA with the same stage e.g. CS1 and than return 1 with the lowest date, 2 for .... and 3 for the latest date.…
-
Countif Function Question
I am stumped on this for some reason. I have a column called "Past Due" that is a Symbol column. I am looking for all tasks past the due date using this formula, =IF(TODAY() > [Target Date for Resolution]@row, "Red"). This works fine. My issue is when I try to count how many past due tasks, or red circle symbols I have in…
-
Copying a Sheet & Using Formulas Changed the Form Attached to Original Sheet
Hi SmartSheet Community, I came across an issue with copying a sheet and the form that was attached to the original sheet was modified from using a formula in the copied sheet. Original Sheet Name: IHA Copied Sheet Name: Copy of IHA INDEX/MATCH Sheet Name: Job Model After I copied the IHA sheet (File --> Save as New), I…