-
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},…
-
Bridge Javascript/Call API & Control Center
Hello all, I have had some success with using the Smartsheet API using the PythonSDK. I am currently using Control Center to create some projects, but they get created in a workspace instead of a folder within a workspace. I have had some success with using the Smartsheet API using the PythonSDK to do something similar, so…
-
Issue log linked to requirements on a different sheet
Hi, I have searched and searched but can't find an answer, but I can't believe this hasn't been asked before so must be doing something wrong. I am running a post development support project where we have multiple regular releases. We gather requirements from the client develop them test them, resolve issues and release.…