-
Collect Criteria not being filtered
My nested COLLECT function's Criteria does not appear to be working because the formula runs into errors when a duplicate date is found before the actual date that should be being pulled. =INDEX([Baseline Variance]5:[Baseline Variance]128, MATCH(MAX(COLLECT([Task Complete Actual]5:[Task Complete Actual]128, [Milestone Type…
-
Count Month from Date Value field
Hello. I have setup a JIRA extract to provide raw data on which to develop an operational dashboard. I need to be able to count 'closed this month' on the dashboard. I am getting a closed date for each row from JIRA and, since this is an automated extract feeding a live dashboard, creating another column to extract the…
-
Helper Column Parents and Tasks with 0 Children
I am using this formula in a helper column to identify which of my rows are "parents" however I would also like to Identify Rows that are Projects or also "Parents", but have 0 children " so that I can tag in conditional formatting along with my Parent Rows that have children. Can you help me create a formula that can do…
-
Find Value in List in Cell
I have two sheets---one with a list of program that includes rows with a cell that has a list of course prefixes. EXAMPLE: ROW 1--->Doe, John | doej@xx.com | BUS,CUL,MGT ROW 2--->Smith, Elle | smithe@xx.com | HOS,SUS Each row has three columns: name, e-mail address, and course code prefixes. On the second sheet, I want to…
-
Creating formula in smartsheet
Hello, I have a requirement to calculate the remaining shelf life of products at the time of receiving in percentage. My formula is: (Production date + Expiry date) / (Expiry date - Delivery date). The end result should be a percentage. Can anyone help me to achieve this? Regards, Jasmine
-
Time
Hi all Is anyone aware of any time functions is recent updates, I what to be about to calculate how minutes/secs(don't mind either) from a system column also is there an hour or minute function in Smartsheet? thanks in advance
-
Parent row based on children status and due date formula
Hello, I have a sheet that tracks event deliverables for 150 or so events each year. The way the sheet is set up each parent row is the event name, and then the children rows are each task for that event. I have a column for Status with the options for Complete, Not Started, and In Progress. I want to create a new column…
-
Sumif if question
Hey folks, Working on a sheet to sum up if checkboxes are selected and running into an issue. The formula I have now is- =SUMIF(PRD50, 1) + IF(Stories50, 1) + IF(Assets50, 1) + IF(Wires50, 1) + IF(Comps50, 1) Each one of those are checkboxes and I want to tally them all up. Ideally, I'd like it to equal 100 since that…
-
Sheet formula to access members in a group
I've created a Group and can track assigned tasks in a Resource View with the group dynamically. Is there a way to access the group list in a formula on a sheet? In my sheet, there is an "Assigned To" column which is a Contact List type column. The cell can be assigned to group members and non-group members. The next…
-
Creating formula to insert text data from one cell to use as hyperlink address for other cell
Hi guys, very new to formulas so not sure if this is even possible and/or makes sense. I have a web form that lets the user submit data for: NEWS PIECE TITLE NEWS PIECE FILE (UNC path) Then, I send an Update Request to our website team who upload the "NEWS PIECE FILE" from the UNC path onto our website, and provides the…
