Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please
Visit the Current Forums.
Discussion List
Percent Complete not adding up
I need some help figuring out how to make my "% Complete" column reflect the actual percentage using my "Hours" column and not "SLA" (days). The sample below is clearly incorrect. It should be more like 64% complete. I'm totally stumped.
Compare text in two different columns
I have a large SS that includes two rows of columns...one is the listing of the latest print revision, and I want to compare it to another column reporting which revision the part was actually built to. Both of these columns are populated with a letter (NC, A, B....AZ). My goal is a Conditional format color if the two…
JIRA Integration: automatically fill in "Start Date" when a Status has been changed?
Hi Smartsheet Community, We've integrated JIRA into Smartsheet. We're looking to automate some more fields. When using the gantt charts, some of the field we are manually filling are and Start Date and End Date. Is it possible to accomplish the following? 1) When a JIRA [Status] has been switched from To-Do --> In Progress…
Master Project Sheet vs Master Project Report
We are looking at implementing either a very large (roughly 160 columns) master project sheet or a master project report. If we go with the master project sheet, teams would work off reports to update their respective data. If we go with the master report, I would aggregate specific data from each team sheet. The end goal…
Comparing offers for the same job from different providers
What is the esiest way to make a spreadsheet for comparing prices?
Excel rows
how do you get around this limitation??
import csv or other file into existing project
We have been working with Omni Plan and would like to import existing project management schedule files into our SmartSheet projects that have already been started. Eventually we'll do all the project schedule management ( we're a construction company) as part of the sheets but we're new at this and I don't need to stress…
Triggering a notification based on the dates of two rows
I would like to create a notification to let me know a task will be finishing late, which will impact the start of another. IF the 'Finish Date' of task 'Narrative' is greater than the "Start Date' of task 'Review' send notification You can see in the screen shot that Hillary is going to be impacted on starting her work…
Sheet Name in Task Name
Is there a way to display the Sheet Name in the Task Name or do I have type it in for each task?
Possible to do a bulk delete of sheets?
Ownership for some sheets that are shared with our VP of the PMO was transferred and when he got the notice he decided we need to clean up (delete) our Smartsheet ancient history. The number of impacted sheets (older than 3 months) is laughably small and I can easily delete them manually but I can't see them since I don't…
