-
MAX(range)
Finding the maximum value over a range is a simple matter given Smartsheets formula. How does one filter the data in the range? That is, find the maximum value of the data in a column given, in my case, two conditions. If the row contains column cells where these conditions are true, then include the data in those rows for…
-
Due Date is Past Due - Checkbox
I'm trying to write a formula that will "check" the checkbox if the Adj End Date is Past Due and the % complete is not 100%) I started with just the Adj End Date portion and have not added the percent complete to the formula. This isn't working... =(IF(TODAY() > [Adj End Date]5,TRUE,FALSE) I then want to do conditional…
-
Notifications - Summary of changes in Email
Is there a way to send out a notification update that will either include the exported attachment of the sheet or just a list of the recent updates in the body of the notification email. I would like to send out an update to a large audience that do not have license or access to smartsheet, but I want to make it easy for…
-
View/Comment Only?
I'd like to allow people to view my sheet and comment on tasks without being able to make any other edits. It would be great to have more specific control of user permissions to make this possible. Maybe somebody has a creative way to do this with sharing/publishing?
-
how to change the duration from days to hours
i have several sheets that i combine into one master sheet. the problem is when i link a cell that has hours in it, it translates that to days and is throwing off the calculation. how can i change the duration column so that it represents hours and not days.
-
Hyperlinks
Help! I have added hyperlinks to my master register but when I look at the report for those projects the hyperlink isnt showing to the sheet. Is this a bug?
-
Change the owner of a workspace
Hi, It's possible to change the owner of Worksheet. But is it also possible to change the owner of a Workspace? kind regards, Wouter
-
How to Generate Automated Daily Reports
I have created reports which I need automated to run daily; is this functionality available? If yes, what is the process? Thanks!
-
Resource Views not Loading on an Apple Mac
For some reason the resource view will not load on my Mac, has anyone else experience this?
-
Account Suspension...
Our company will be needing Smartsheet to jump through a few IT hoops before my department can make full use if its features. In the mean time, what would happen if for some reason we had to suspend our account? Is all of the data in the sheets lost? Or is the information stored for a time until we can reactivate our…
