-
End Date minus x#of days =start date
Hello! I am trying to enter a formula in a group of rows to have the end date -180days = start date column, but i've tried several different formulas and they all give me an error? Does the dependency to the parent row cause any issues for this - the sheet has 400+rows and i only need the formula in ~7 of them to equal the…
-
Help counting duplicaes in a column but not blanks
Hello, I want to count duplicates in a column but not count blanks. Any assistance appreciated. Az This formula works but it counts the blank cells =COUNTIF([Name (Last, First)]:[Name (Last, First)], [Name (Last, First)]@row) This formula results in all '1's but doesn't count blanks. =IF(COUNTIFS([Name (Last, First)]:[Name…
-
s there a way to have the Status roll-up here?
Is there a way to have the Status roll-up here? Meaning, can the row show a status based on what is noted in the Child? As an example, there are 4 rows under this parent. If the average was OnTrack, then the overall goal is OnTrack and so the status would change to OnTrack?
-
Can you display a full sheet on a dashboard without having to duplicate the sheet in a report?
I have creating a dashboard with metrics. I also want to include the full sheet at the bottom. Can you do this without having to create a report that also includes everything on your sheet?
-
Project Health formula Help needed
=IF([Schedule Delta (%)]@row > 0.1, "Red", IF([Schedule Delta (%)]@row > 0, "Yellow", IF(TODAY(10) >= [End Date]@row, IF([% Complete]@row < 0.75, "Yellow", "Green")))) These is what I want the rules around the health to be but when i enter the above formula the cell is blank some of the time. If scheduled end date is…
-
Formula Help
Hello- I am trying to subtract the most recent # of vaccines on hand from the sum of the total vaccines delivered- any suggestions? Tried this but it did not work: =(SUM([If you got a shipment, how many doses were in it?]2:[If you got a shipment, how many doses were in it?]61)) - (INDEX([# of vaccine doses on hand today…
-
Parse multi-selection cells
I've poured over several threads about JOIN() formulas, attempting to parse values from a multi-selection cell [Supply SKU]. The end goal is to use those values to lookup another sheet to bring in a cost. The A,B,C formulas in this thread are the first to get the result I'm looking for however, I have up to 14 values that…
-
Forms - Auto population functionality
Hello there, I am working on a project where I am collecting data via a primary form. My question, is there a way to auto populate a new form (sub form) with the fields / data that was submitted on the primary form? Thank you! Alexandra
-
Formula - Completed projects in a given year
Hello, The formula pasted below works great if I want to count the number of projects completed in a year. How can I revise the formula so that I can count the number of projects completed in 2020? Thanks!
-
Does anyone know does the automation update form has an expiration time/days to the link?
Once you received the update form from smartsheet, how long do you have till the link is expired/no longer available? Or is it that once you click "open update form", it wouldn't work the next day!? Thanks!