-
Automating weekly notification
I need some advice on creating a workflow that will meet the following requirement. We created a calendar and online booking form in smartsheets to allow people to submit requests via the form to attend an event. These requests are triaged each week, and a decision is then made to either Approve, Decline or alternatively…
-
Hi, can I get help to know why I am getting #UNPARSEABLE for this formula?
=IF(OR(Done671 = 1, [% Complete]671 = 1), "Green", IF(OR(TODAY() > [Due Date]671, [Team Issue]671 = "Major issue (Red)"), "Red", IF(OR(TODAY() > [Due Date]671 - 5, [Team Issue]671 = "Minor issue (Amber)”, TODAY(INT(Duration671 * (1 - [% Complete]671))) > [Due Date]671), "Yellow", "Green")))) Please note I have ensure all…
-
Report to display content of one specific row
Hi there, We have a sheet that gives an overview over all our projects. Each line is a specific project. There are around 30 columns with various dates etc. Is there a way to create a report or dashboard to show specific columns content for one row alone? So like to add a report/widget to the project specific dashboard?…
-
Dashboard Notifications if items in Dashboard have changed
Hi, I was wondering if it's possible to notify a custom list of users based on any changes on the dashboard. This reminder should be customizable. Basically, the idea is to alert users of changes in dashboard without them having to pull the dashboard to view changes. Thanks
-
Forms - SmartSheet Form not the same as Form received by Action Parties to enter data
I have a Smartsheet that tracks Action Items. I created a Form that shows Action Parties data from Smartsheet and requires them to enter responses. The Form sent to Action Parties that appears in Emails and can be opened from the Email to enter responses does not contain the same cells as the Form in SmartSheet. Why? See…
-
Free Collaborators
I have a sheet I set up to track work orders from industrial properties around the country. I collect the data through the use of forms that i have sent via email to each of the property managers who are not licensed users. This has been great to get work orders started and assigned to people in my office. Once they are…
-
Resource view in dashboard
I have read many discussions on wanting to show the resource view on the dashboard. Has there been any progress on making this happen?
-
#CIRCULAR REFERENCE auto corrects after I copy and paste the exact same formula.
I have theories as to why this is occurring but, for now, here is what happened. One of the sheet formulas looks something like this: =IF([COLUMN A]1 = "YES", INDEX({Smartsheet 1 Column B}, MATCH([PROJECT#]1, {Smartsheet 1 Column A}, 0)), IF([COLUMN A]1 = "NO", INDEX({Smartsheet 2 Column B}, MATCH([PROJECT#]1, {Smartsheet…
-
Is it possible to format column headings?
One of my users would like column headings center aligned and bold. Is it possible to format the column heading? The format applied to the column (alignment, font style) do not change the column head. Thanks, Susan
-
Clever ways of recording when a task moves from one stage to another
Hi all, Can anyone think of a clever way to record when a task moves from one stage to the next, or how long a task was at each stage? Our standard task has 5 stages to go through before it is complete. My boss wants to be able to analyse how long each task is taking at each stage. My first thought was to put a date column…
