-
How can I make FS dependencies start on the same date the predecessor ends?
Hi everyone, I’m migrating a schedule from MS Project to Smartsheet and I noticed a difference in how FS (Finish-to-Start) dependencies behave. In MS Project, when a task has an FS predecessor, the successor’s start date is set to the same day the predecessor ends. But in Smartsheet, the successor is pushed to start one…
-
Delete All Comments
We often reuse Smartsheets from one year to the next. It would be helpful if there was a method to delete all comments the same as you can delete all attachments. (If you can't do this with proofs, that would be a nice addition also.)
-
Generation of a Project Management tool/tracker
Please could I have some advice before tackling the creation of a tracker. I need to create a sheet which tracks the progress of multiple documents which need reviewing by various departments. Ideally, the tracker would show the outstanding actions for each material and the status/work flow of the material is unable to…
-
Upload option missing from form
I am unable to include a file upload option on one of my forms. The form already has one upload, could this be why? I have checked the storage, and that is not the issue, and i checked another form and the option is available.
-
Azure DevOps Dashboard
I’m trying to display my Azure DevOps dashboard within my Smartsheet dashboard. I attempted to use the Web Content widget by embedding the dashboard URL, but it didn’t work. My goal is to show the status updates and charts from Azure DevOps directly on Smartsheet. I’ve successfully used the Web Content feature before, so…
-
Procurement
I'm interested in how people are using SS for procurement and grant management in government? Are there templates you have found especially useful or have you made your own? I transferred to a new division a year ago and they had made their own. I'm hoping to eliminate duplication and help add automation to future…
-
No signatures please
I would like to ask people to remove/shorten their signatures when they post/answer a question. Especially those that post/answer with one line of text and have a 30 line signature that repeats over and over again for each post/answer. /marc
-
Link existing table
Hi, I have a table which is linked to database and the table would have new row add. I want a table that have the same data and I can insert a new column to calculate the data. I've found some ways: Cell linking, Report, Connect Your First Sheet to a DataTable. If I use Cell linking, I need to maintain it manually. Report,…
-
P6 to Smartsheet Gantt (anyone try it?)
What I've done Exported from P6 (Activity ID, Name, WBS, Duration, Start/Finish, Preds w/ FS/SS/FF/SF + lags). Normalized in Excel and generated a Smartsheet-ready Predecessors string by converting P6 Activity IDs to Smartsheet row refs (e.g., 23FS+3d, 28SS). Imported to a sheet with Dependencies ON; built WBS hierarchy;…
-
SUMIFS Unparseable Error
Hi, I'm attempting to use SUMIFS to sum data (Royalty Rate) from another sheet if the Project Number in the other sheet (Project Num) matches Project Number in the current sheet, and if Based on from the other sheet is "SRP". Current formula that isn't working is below. =SUMIFS({Royalty Rate}, {Project Num},[Project…