-
Setup weekly Reminder till task is "Complete" - Reg.,
Hello All, I have a set of tasks which i requested my team to update once a week. In order to remind them, i want to setup reminders so that they receive email once a week. I saw someone telling to create report and setup reminders. But, i could not figure it out. Request for help here. Thanks & Regards Srinivas Poosarla
-
Workspace Project Tabs
I have searched and cannot find the answer to my question. I have several project tabs open but when I switch from one to another, it last tab will arbitrarily change to a different project from my Sheets list. (I have marked some as favorites hoping this would keep them open but it doesn't.) I then have to go to my Sheets…
-
Update request missing option to change end dates
Hello, I'm a rookie to smartsheet and PM work. I have sent out my update requests and my partners on the receiving end are telling me they cannot update the end date field. They are able to edit every other field. Can you help? Does it have something to do with changing the end date of the parent row first? Thanks! Monica
-
Webform vs Request Form
I really like the Webform feature. It's made things easier with coordination and data entry. Could I also upvote a feature for Request Form (as an extra step)? It would nice if the submitted Webform goes directly to the sheet administrator first to approve before it goes to a sheet directly. Not because it's been submitted…
-
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?