-
Find previous date for then calculate days between dates
Hi all, I'm having difficulty creating a column that shows the number of days between jobs at the specific venue. Sheet is essentially a list of jobs at various venues. VENUE A, 02/02/23 VENUE B, 10/02/23 VENUE C, 15/02/23 VENUE A, 16/02/23 The column I'd like to create would show the last row for VENUE A as 14 days. I'd…
-
Trying to get a dashboard to update with the most current entry.
I am building a weight loss dashboard for a client, that they can use for their clients. Everything is working how I want it to except for the current weight. I am trying to get that to update based off of the most current weigh-in weight that is added via the form. In the picture below it should be 180. I am trying a…
-
Accurately Count if Multiple Contacts are in a Cell
Hi, I am really struggling trying to map out certain data points, when it involves our sales reps, because we can have multiple contacts in a single cell. In this particular instance, I want to find out how many quotes a sales rep has issued this year. Problem is, multiple sales reps can quote the same job, so another…
-
Cross-sheet referencing to count across multiple columns for a matching row. Can't figure it out :(
I created a metrics sheet that references my G-List sheet. In my metrics sheet I'm essentially trying to say, "Look at the matching [Ops ID No.] in the portfolio sheet (G-List) and count the number of cells across multiple columns that have no dependencies indicated (i.e. ="None")." The common column in both sheets is [Ops…
-
Invalid value (Problem with RIGHT, SUBSTITUTE and VALUE Formula
Hello, As the picture below shows, I am trying to extract 2 numbers from a cell that displays different formats (paper sizes). I need to set up a calculation with the 2 numbers. That is why I use the LEFT and RIGHT Formula to extract the text and the VALUE formula to change it to number format. I also use the SUBSTITUTE…
-
UNPARSEABLE IF AND MAX FORMULA HELP
Hi Community, Can you tell me what is wrong with this formula? If the automatically populated created date is Max it returns 1 if not 0. =IF(Created@row ={MAX}Created:Created),1,0)
-
Return several values via a vlookup
Hello all, is it possible in smarsheet to use a vlookup that would return several values in the same cell. I have a sheet with the list of users and the departments they belong to. I then have a sheet with the tasks of a project with a column that contains the users in charge of a task, each cell allows the addition of one…
-
Changing Status and Health Based on Percentage
Hi guys! I'm fairly new to Smartsheets (and project management) and i'm the first and only project manager at my company. I was looking for help with conditional formatting and and IF AND function. Any and all help would be greatly appreciated! What I'm looking to do is (seemingly) basic: If my "Percentage Completed" row…
-
Create a sheet that lists all working days in the date column
I am creating a template for a daily log for our job sites. I want to find a quick way to fill in our working days into the rows so I'm not manually typing or clicking and dragging and deleting every weekend day, does anyone have a formula for making this happen?
-
IF(JOIN(COLLECT())) issues
Hello, I have the below formula working correctly and returning the Rally Status if the User Story field has one User Story in it. Unfortunately, I need it to return all the status separated by a delimiter of ", ". For example, 'US1234567, US1234568, US1234569', I need to return status like, 'In Progress, Closed,…
