-
Question on Forms
Good afternoon. I have a question for you. I am using Forms for my spreadsheet. I have 7 days beginning with Monday. I wanted to do different sheets for each day. This is so the user would not be confused. Each day is placed on a separate row, Is it possible to have the forms Mon-Sunday show on the same row? In other…
-
Is there a way to create a column that re-numbers automatically when rows are moved around?
I feel silly that I cannot seem to figure this out. Is there a way that a column can contain a number that updates automatically when rows are moved around? For example, if the rows are numbered 1, 2, and 3 - in order, and then I move row 3 in between rows 1 and 2, I want that cell to automatically update to become 2 and…
-
Monthly Count of Request Types
Good day, I am looking for a formula that can count the number requests of a certain type in the current month. For example the two columns I have are "Request Type" and "Request Created." The request created is the standard request created column built into Smartsheet. The "Request Type" column has multiples types say…
-
How tu sum durations of the task and it's predecessors.
Hi All, Is it possible to sum in Smartsheet the the duration of the task with but also with the durations of the predecessors of this task? for example task 3 lasts 3 days but it's predecessors are task 1 (4 days) and task 2 (5 days) (typical FS). so the duration of the task would be 3+4+5 (in some helping column). Thanks…
-
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 -…