-
Moved a sheet and now the data won't show up in reports
I had a full project plan in one folder. Then, I saved as new in another folder and deleted the original. The original plan was showing up in reports just fine. But, the new version will not show up in any reports. I have ensured that the new folder is selected when I build the report. I've even created test reports that…
-
Approval: two users/same level
Hello, Is there a way I can send an approval form to two managers who both need to sign off on each staff member's annual leave? I can do it if I send to Manager A first and then Manager B once the first step has been completed, but wondered if there's a way to do them both at the same time that I'm not seeing...?
-
How do I add text to the end of a formula?
I have a formula that calculates the number of days and would like to add the word "days" at the end of the formula. In Excel, I would use '& "days"' as in =NETDAYS(Added1, Closed1)&" days" ...
-
Red Flag If statement
I have an if statement that is doing what I need except when there is no value in the deadline column. I want to keep the functionality I have but make sure the flag is not red when I have no deadline set. =IF(AND(Deadline2 < TODAY(2), Completed3 = 0), 1, 0)
-
Unrecognized System Contacts
I'm seeing behavior in a sheet that I'm not sure if this expected or not. I am a known contact in our corporate instance of Smartsheet. The screenshot displays content in a sheet column that is created by submission of a form. For this particular column, it's populated from an email address in the form field. Submitters of…
-
Automated emails
I would like the ability to send an automated email to a sheet assignee at a certain time with attachments linked on that line in the smartsheet. preferrably I would like to be able to create a user group instead of a single assignee so that the email can be sent to multiple people but at this time it cannot be automated…
-
Averages with Errors
Hello, I'm trying to take an average of a range of cells. Some of these cells have a #Divide By Zero error in them because the source sheet does not yet have applicable data. I have used an IFERROR statement to change these cells into "blank" cells, yet when I use the following formula: =AVERAGE([Avg. Functionality]1:[Avg.…
-
Milestone Tracking Report - Numerous projects
Hi all I'm trying to create a status report which would roll up project tasks and their progress into an easily view-able report and/or widget The data will be across multiple sheets and I'm trying to find a way to trigger both active, complete and in progress data sets so that I can target the relevant stages inside of…
-
Scrolling with a mouse wheel
This is a minor thing but trying to figure out how to scroll up and down in my sheets using the wheel on my mouse. This works in every other piece of software I use but in a Smartsheet I have to use the slider bar on the side to move up and down through a sheet.
-
Task Dependency Block View
Would be awesome to be able to see projects in a format like that used by Casual.pm. Gantt charts make it very easy to see how tasks lead to deadlines, and to identify critical paths, but they are not great at immediately showing how tasks depend on one another, nor the total number of processes in action at any given…