-
Trigonometry Functions (Sine, Consine, Tangent)
I was quite disappointed that SmartSheet does not have basic trigonometry functions such as sine, cosine, and tangent. Pretty basic and available on other software tools.
-
How to have each subsequent value that matches a criterion appear in its own cell in a column?
I'm trying to pull change order numbers that are assigned to one specific person in a source sheet appear as separate entries in one column in another sheet. I've gotten it to manually work with this formula: =INDEX(COLLECT({CO Number}, {Assigned PM}, "PM Name"), 1) But I have to manually adjust the number at the formula…
-
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: Return Sheet: What I'd like to happen is… on the Return Sheet: When a value is entered in the Constituent Number column, the sheet returns a corresponding value in…
-
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…