Using Smartsheet
Want to know more about using forms? Interested in better understanding automation? Want to see what's possible with dashboards? Post your question or discussion to Using Smartsheet.
Discussion List
-
why does my conditional formats fail to function when the set conditions exist?In Using Smartsheetwhy does my conditional formats fail to function when the set conditions exist?
-
Ticketing Sheet: Update Request to Group?In Using SmartsheetI'm using the ticket template and want to use the update request feature. Currently it seems like the only way to do an update request is to assign it to a specific user, which doesn't make sense if you have an entire department working on…
-
Gantt Report for Several Sheets - Can I drag & drop dates in the report?In Using SmartsheetI would like to be able to drag & drop Gantt dates in my report as we have several projects going concurrently, and the report is great for big picture. How do I do that? Also, how do I reflect a pause in a project, as in we're wait…
-
Nested IF StatmentsIn Using SmartsheetI'm trying to add the below "IF Statement" but I get the "#UNPARSEABLE" error. "Weight22" is cell that contains the "70%" (which is calculated from a formula. I want the IF Statement to return the &…
-
Sumif Help pleaseIn Using SmartsheetI want my totaling cell to add quote on the criteria below. I have a drop down list in column 1 , in that list I have (con/fine, con/course, con/xtra, ash/fine, ash/course, ash/xtra. grind/fine, grind/course, grind/xtra........this contin…
-
Resource view for multiple projects in a single sheetIn Using SmartsheetI have couple of 'Resource View' questions... 1. Is it possible at all to use a single sheet to have multiple projects (as multiple parent tasks) and have 'resource view' to show the allocation against the parent tasks rather than multipl…
-
planned % completeIn Using SmartsheetHi guys, any advise on how works with % completed vs planned % completed as smartsheets only has column for % completed?, has anyone achieved to make a similar column for planned %?
-
Suggestions for Calendar SyncingIn Using SmartsheetHello, I recently had an issue with calendar syncing, you can see the thread here: https://community.smartsheet.com/discussion/resyncing-google-calendar As you can see in the response to the thread that a resync option isn't available. I…
-
How can you edit a collborators e-mail address?In Using SmartsheetI want to edit an e-mail associated with a collaborator because it has changed. There seems to be no way to edit anything in the Sharing area. I know how to edit My Smartsheet Contacts, but that doesn't help. Sometimes the collaborator …
-
NotificationIn Using SmartsheetHi all, I need some help... Whilst I am of the understanding that you can set up notifications when a user makes any changes to a sheet, is there any way you can be notified if someone has in fact opened a sheet they have been invited to…
