-
Rank Values By Group
Does anyone here know how to rank values by group in smartsheet? In excel, it's done like this below.
-
How can I count by date?
I attached a screenshot of my sheet. I want to count the number of Block ID instance per date. Any tips? The end result would be a count of Block IDs in each cell that has a "Hierarchy Translation" == Date
-
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.…