-
Sum IF Help With a Formula - I think it is SumIF
Hello all, I have a sheet with a column that has this formula in a column labeled "This Month Available Hrs Remaining" =NETWORKDAYS(TODAY(), IFERROR(DATE(YEAR(TODAY()), MONTH(TODAY()) + 1, 1) - 1, DATE(YEAR(TODAY()) + 1, MONTH(TODAY()) - 11, 1) - 1)) * 8 * Count@row This formula lets me know how many man hours I have…
-
Smartsheet Data Shuttle how can you manage the large number of uploaded files
I have a Data Shuttle the receives a new version of a spreadsheet every 15 minutes. As you can imagine I now have thousands of versions being stored on the sheet. I have two questions 1 Is the number of stored versions creating a resource issue on my sheet 2 How can I automatically archive or delete the number of versions…
-
How to return the value of an adjacent cell for a summary sheet to show phase or step in a process
How can i use an IF statement to return the value of the adjacent cell in the PHASE column for a status cell that is IN-PROCESS. Or is there an easier way? For any Status of IN-PROGRESS, i want to return the Adjacent same row Phase value. From below something like: If Status column = IN-PROGRESS then show Phase column…
-
Printed Report not keeping sort order
I have a simple report that has a sort order selected. Works great on the screen, but when I print the report, the sorting seems to have a mind of its own. I cant find any rhyme or reason of what its sorting. Trying changing the sort to other columns, but no luck. The only think Ive been able to notice is that at least its…
-
I need an Attendance Tracker Template
I have a Daily meeting that I would like to record attendance for. In our meeting we have about 30 different members. I would love to be able to record the attendance on a sheet. Pull a report from the sheet. Then display a dashboard that shows attendance data. Are there any templates that would fit this?
-
Need help with creating formula/function to determine asset availability
Hi All! This is what I am trying to achieve: I would like to add a function or formula in 'Availability' column to determine if the Vessel(s) selected in 'Vessel Type' column are available or not for newly 'Submitted' rows. Condition to check availability: Compare Start Date and End Date for Vessel(s) in 'Submitted' with…
-
Formula Help
HI all, I have a sheet that has a column with total Jan Work hours available and i have another column that names the production division that those Jan work hours belong to. I was to create a column formula in a new column that provides the total Jan work hours available for Structural Shop Team Hours I think it is a…
-
Copy row to another sheet by COUNT until COUNT = 0, or other Parse option
Hi folks, I've got rows that collect courses for students into the COURSES REQUIRED column separated by commas. I've already setup a formula to count the number of courses found there What I'd like to achieve is that for each student/row containing multiple classes in their required list ... parse that students row such…
-
Access & Work Off-line within Smartsheet (Sheet level)
Enhancement Request: Access Smartsheet off-line and allow work to be saved for upload at a later time or once online access is available. The most common use case is travel (i.e. airplane, passenger in automobile). However, there are scenarios where internet service is compromised (i.e. warehouse buildout, remote areas…
-
"Hello SmartSheet Community. I am trying to capture weekly data amounts based on specific date range
"Hello SmartSheet Community. I am trying to capture weekly data amounts based on specific date range referencing another sheet. I thought this formula would work but keep getting back an error. =COUNTIFS({ACF Conferencing Request Assigned Host and Tech}, CONTAINS("Alexander Tsehay", @cell), {ACF Conferencing Request Date},…