-
Formula with multiple IF criteria
Hi all - Trying to create a formula that raises a flag any time a milestone is NOT marked complete AND the due date has past. Below is what I have tried and I am receiving an "Unparseable" error. =IF(Stage2<>"Complete" AND [Due Date]<= TODAY, 1) I am not sure that I am combining the two statesments correctly. Can anyone…
-
Automatocally changing due dates and status on recurring tasks (Monthly, weekly, etc)
How do I make a row update the due date for a monthly, weekly, and/or quarterly recurring task? I would like it to automatically change the due date to one month, one week, or three months in the future and change the status back to Not Started once a recurring task is marked Complete. I need to be able to do this at the…
-
SmartSheet Recent Update - Attachments/Versions
With the recent update to SmartSheets, our company has seen a few issues. The first issue has been the version numbers. If you look at the example below, the version numbers are out of order. We deal with a variety of freelancers that don't work for the company, but rely heavily on the version numbers. Now with them being…
-
Viewing Smartsheets from MS Teams
Hi there, I'm having a bit of an issue that when I add Smartsheet as a widgit to Teams to display a sheet the filters I have created for that sheet in SS don't carry over to Teams. Does anyone know why this may be?
-
Cell Linking Issue
Hi all, I am new to this community but have read numerous feeds posted here and found them really useful. I have now run into a problem of my own that requires some help. I have created a form for our business to complete. The completed lines (Cells) are then linked to another sheet for data collection. The problem here is…
-
FILTER
Hi, Please can someone suggest an dynamic alternative for Smartsheet to the FILTER function that Google Sheets have to include in a report. I have a list of Asset I.D's that have multiple statuses at any given time. I would like to capture each Asset I.D assigned to each person according to the Asset's status. ie: all…
-
PMO Governance templates ?
Team, This question may not be related to smartsheet. Based on your experience, what is the best source for ready-to-go powerpoint templates for PMO documents like Charter, status report, Budget summary. I know there are some online paid ones. But wanted to see what you all recommend. Thanks
-
Index Match Values Based on Certain Parent Rows
First, awesome community! I've been looking all over for a solution to my problem, but cannot find anything that would translate to my situation. Hopefully I make some sort of sense describing my issue. Brief: I work for a construction company that specializes in high rise construction. For my department, I'm tracking…
-
Cross sheet Formula to pull in column value
Hello, I have a Master Server Inventory sheet with columns such as Server Type, Server Name, Recovery Method, and several other columns with common data that has to be collected for all servers. I need to create a variety of separate sheets with detailed configuration data about each server. I want to reference and pull…
-
Disable Notifications/Reminders while "building" schedule?
My team and I are getting notifications and update reminders for sheets that I am still building (it is a copy of another sheet I'm using to create a template and it has all the built-in notifications we eventually want). Is there a way to "disable" the notifications until the schedule has been baselined? I don't want to…
