-
Why doesn't my mouse wheel work within a sheet?
Scrolling through a big sheet with the wheel on my mouse would be great. The scroll wheel works in every other thing I do - including parts of Smartsheet- just doesn't work within a sheet. I've changed settings on my mouse but still does not allow me to scroll within a sheet- forces me to grab the slider on the side or…
-
Is there a way to define "today's" health, based on today's date and corresponding "% completion" va
Hey everyone, I've got a set of data pulling in completion % by date, and want to give my team a quick snapshot of overall health of the project based on completion % for TODAY(). I have used the following formula, which works for giving RYG per day: =IF(AND(Date9 = TODAY(), Difference9 < 0.05), "Green", IF(AND(Date9 =…
-
Countifs formula error
within the same report as my list of projects I'm trying to return a count of projects that are due to start within the current week (day 0 - 7) from "today" then return a count of project for next week from (day 8 - 13) then week 3 (day 14 - 20). here's the formula I came up with but it's not working.…
-
Notifications not including attachments or comments
I set up a notification alert to send an update once a column is checked as "done", and was to include all items in that row, including attachments and comments. However, I am not receiving the comments and attachments. Please help.
-
Report Design - How to show higher level task with late sub-tasks?
I am working on a couple of reports and they are working fine except I cannot see within the report the higher level task which has a sub task that is late. For example: Task Sub Task - OK Sub Task - Late Sub Task - Future. When I get the report to identify the late sub-task, I'd like to be able to see within the report…
-
Reporting Using Parent Child Relationships
Hello - I have created a report to display the current user's list of high level milestones. This list is supposed to display any milestone that is blank under parent child relationship. This ensures only high level tasks are displayed. Its seems to work fairly well, but I have encountered one issue. For one of my sheets…
-
Smartsheet and JIRA integration
Hi, I have two questions related to Smartsheet and JIRA integrator and I'd like to know if somebody here could help me: ** Question #1: Is it possible to insert a row (automatically) within a parent structure from JIRA integration? For example, suppose I have this smartsheet: Marketing Team Tasks Task 1... Task 2... Task…
-
File Upload from Customer into their Designated Row
I was hoping somebody could help. I have a form set up where customers can upload their artwork directly to our sheet and once checked I send an approval request as a proof. However if the proof is declined or we check the file and it isn't print ready we require customers to upload a new file (artwork). I have tried this…
-
Template document control
If you create a template in Smartsheet, does that template have any type of document control, history, or revision numbering assigned to it? We need to keep control of revisions to the templates and would like to know the best practice for this in Smartsheet. Thanks
-
Help with formula (IF > AND > THEN)
Hi team, Could you kindly help me out with the formula syntax for the following scenario please: If the "Rag Status" column is 'Red', and the "Complete" checkbox is not checked, then the "Action Status" must change to 'Overdue'. Link to sheet is HERE.