-
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?
-
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 Entry Formatting
I'd like to suggest an enhancement for the formula bar in Smartsheet. As it stands, users are unable to expand the formula bar or input/format multi-line formulas directly. This limitation is particularly challenging when dealing with complex formulas, where keeping track of parenthesis pairings and overall structure is…
-
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…
-
Formula to Calculate Time Taken Between Two Date and Time Columns Stored as Text
Hi Community, I’m trying to calculate the time taken between when something was ready and when it was picked up. I have four columns: Ready Date (Date column) Ready Time (Text/Number, format like 4:05 PM) Picked Date (Date column) Picked Time (Text/Number, format like 4:05 PM) The challenge: Since the time columns are…
-
Use index, match and left to match a set of strings from another sheet
Hello, I am using the formula below in order to match two data sets together. It works fine. For my next task I am trying to limit the match to only the first 12 characters of the string. I am trying to fit in the left function and using 12 as the character count, but I am getting errors. Here is the current formula I am…
-
Formula in Sheet Summary returns different count result than filter
I am trying to count new entries in a list added during the previous week. If I filter data on "Create Date" between the dates for Sun-Sat last week (eg 8/3/2025 and 8/9/2025) I get result A (65). In my sheet summary I used this formula: =COUNTIF([Create Date]:[Create Date], IFERROR(WEEKNUMBER(@cell ), 0) =…