-
Ideas on transition between annual project tracker sheets
Hello, I am looking for a way to "connect" two Smartsheets that track a variety of projects (one for 2019, one for 2020). Curious to see if anyone has done this, recognizing that some work may extend into the next year, and if there are any lessons learned / pro-tips in creating and maintaining such a concept. Thanks for…
-
Webform Submission issue
We are currently using our own custom WebForm to submit directly to Smartsheet. This process has been working flawlessly for the last few months. We had had users reporting now that when they hit submit on our php WebForm the old Smartsheet WebForm pops up and is completely blank. However if we go into Smartsheet, all the…
-
Updating a current formula for a report in a widget to include dates
I have an issue where the current formula feeds into the report correctly and displays on the dashboard widget however, I have now been asked to change the formula to be date specific. I need to have this display by our fiscal year (July 1, 2018-June 30, 2019). Pro-desk gave me the formula to copy and paste but the…
-
Auto-populating dates
I have several categories in my 'Status' column. (Sprint Backlog, Planning, In Progress, In Review, Changes, Print Files Ready, Print Req Sent, With Printing Services, Complete, Blocked) I would like to have a date automatically populate when the Status becomes 'In Review'. Then, once that date is populated, and if the…
-
Glitch Moves and Deletes Rows and Columns
Has anyone else experienced groups of rows and/or cells moving in their Smartsheets? It seems to happen overnight with 10-20 rows moving from the top of my Smartsheet to the bottom. This morning two columns were found deleted and Smartsheet doesn't have a revert function so I'll have to rebuild them. This has happened more…
-
Cell formula that will highlight a task expired if any of its sub tasks are expired
Hello All, I'm trying to create a cell formula that will highlight a task expired if any of its sub tasks are expired. For example if a parent task has any child tasks with due dates earlier than the one of the parent it should be marked as expired. Is there a formula available for this? Thanks
-
Right-away notifications not being emailed
I have setup a separete hidden checkbox column for each member of our team with a notification to send an email to each person when the column with their name is checked. The email is to go out righ away, when their column is changed. However, I have been changing and saving and no email has been sent out...some are…
-
Gantt rollup for multiple projects
We are trying to rollup multiple project sheets that have tied in metrics. The gantt view is not allowing us to have the dependency arrows on our rollup. Do you have any suggestions how to create this? We have multiple tasks on our project sheets that have dependencies but our phases do not. I tried copying the dependency…
-
Strip Time When Linking Max Modified (Date) Cell to Column with Restrict to Dates
Hi Smart Sheet Community! I am applying a formula to a cell in our project schedule sheets that I found in a couple posts to grab the MAX value of the Modified (Date) column: =MAX(Modified:Modified) + "" My colleagues and I will be linking the cell with this formula from our project schedule sheets to a "Last Updated"…
-
Office 365 (Form) Web Content integration
I am trying to integration a office 365 forum web content link into one of my dash boards. But I get an htttps error but the shared link does us https. Smartsheets says it has Office 365 integration but is it only for certain tools sets within Office.
