-
Rotating Assignee on weekly basis
Iām building a Smartsheet to rotate 30 assignees on a weekly schedule, with each task spanning one week. The formula I created is returning a ā#UNPARSEABLEā error. Could anybody advise on how to correct it or recommend an alternative formula that supports this rotation? Any visuals appreciated as well.
-
Total Project Count FY2025
Hello, I am looking to count all projects that have "gone-live" FY2025. In my grid, there is a column titled "go-live" that lists the date a project went live. Is there a formula that can calculate FY?
-
Index / Match
Looking for some guidance. Goal: If "KPI Availability %" @ row is equal to or greater than "Annual Score % Availability" row 10 then it will look at the "Previous Contract Year Event" @ row and match it with the column header 0 , 2,3,4,5,6,7,8 (individual columns). Then it will look down the matched column where it matchedā¦
-
Extract Number from Cell that Begins with Text
I need to extract all of the numbers from a column and move them to a column on their own. These cells begin with text. The data is not always the same length. This is a sample of the data. Can you help me with a formula that will extract the varying accounts below 45811050-45811050-77510, 45811050-4581-13120.009,ā¦
-
Networkdays when doing sums
I have a working formula (below) that works well, but includes weekends in the return. I am finding a date in a range, and then adding Duration per products X #products. How do I get it to work with weekdays only? =MAX(COLLECT(Assigned:Assigned, Priority:Priority, "HP 1")) + (MIN(COLLECT([product counts]:[product counts],ā¦
-
Using SUMIFS with Cross Sheet References and CONTAINS
There seems to be lots of information on how to use SUMIFS with a CONTAINS criteria, referring to another sheet. Here is my formula on Sheet 1: =SUMIFS({Total Cost - Final Event Space Cost}, {Requested Event Date}, {Requested Event Date} > TODAY(), {Requested Event Date}, {Requested Event Date} >= TODAY(-365)) Total Cost -ā¦
-
Index/Match formula using a range of values?
Hello, I'd like to create a formula or series of formulas to accomplish the followingā¦ There are two sheets: Source Sheet Return Sheet Source Sheet: https://us.v-cdn.net/6031209/uploads/RY816MEYP46R/example-source-sheet.xlsx Return Sheet: https://us.v-cdn.net/6031209/uploads/ZG5YB9OMWQK4/example-return-sheet.xlsx What I'dā¦
-
Formula to populate price based off 3 criteria
I am new to Smartsheet and am moving a large complex excel spreadsheet into Smartsheet. With the formulas being quite different from excel, I am converting them with some success. But this more complicated one has me confused. I created an example to show what it is I need. I am new to this community, so if I am notā¦
-
VLOOKUP vs CONTAINS
This discussion was created from comments split from: How to detect multiple dropdown values in a contains function?.
-
Extract a MM/DD/YY Date from M/D/YYYY HH:MM
I'm looking for some formula help to convert a date format. The date column I'm referencing is coming in from another source, and is formatted as M/D/YYYY HH:MM - here's some example data from the sheet: I need to compare these dates to a user-set date (column = Prior Run Date) in my sheet, which is a Date column typeā¦