I have a sheet where I am tracking construction progress. There are a lot of data/calculations that my field personnel do not need. I want a simple interface for them to update data (% Complete, Actual Date Completed, etc.) Each…
Over the past couple of days, I have searched and read every article and even solicited help from SS and have worked myself in a circle.
I have a drop-down list (Submitted, Approved, Declined), I need to "auto-populate" a date c…
Formulas and Functions153DENVER DEWEES
Our PM's are experiencing a few issues with the Gantt Chart, and I hoping someone can help.
In some instances, per the attached, the overall status suggests that the program is ahead of schedule. This is despite Sub-child 2a being on targ…
Using Smartsheet177Richard Heath
Hello All, I am new in this community and i don't know this is right place to ask this question. I am working as a manual tester, I am confused for the difference in agile and waterfall model as a team coordination point. Can anyone know a…
The New Work/Life Reality33Ankit Dixit
Is there a way where in my form that I had created to be able to customize more logic behind the selected answers? For example -- if a user selects (no) for question #2 ---- and on questions # 5 the user selects (Need more informa…
Hello, I have a sheet where I can see budget, actual and variance for my project budget. So column 1 is january budget, column 2 january actual and column 3 january variance, and so on.
All I want to is to create a line-type chart for my d…
Using Smartsheet57Laura Corredor
I am trying to implement the following formula from my excel spreadsheet into my smartsheet:
=INT(O2-Q2)&" Days "&HOUR(MOD(O2-Q2,1))&" Hour "&MINUTE(MOD(O2-Q2,1))&" Minutes"
Formulas and Functions803LouiseM
I want to aggregate multiple project schedules into a master schedule. When copying the milestones from various projects into a single sheet, my overall Gantt Chart displays an event as a row, and each project occupies many rows.…
Using Smartsheet22Sam Ng
Setting up an alert system that sends out notifications when a form has been completed.
To streamline the process I would like to use a field from the form in the email title to differentiate between the emails rather than a range of emai…
My notification emails are now coming across with a colored background. Is there a way to turn this off in SmartSheet so that I don't have to do it when I forward my emails?
Using Smartsheet42Russ Anderson
I see you can list a task in minute increments, e.g. 15min. We are creating a cutover plan and need to list a start & finish TIME: e.g. 9:00, 10:00, etc. Does Smartsheet have this as an "intelligent" column or just a text/n…
Using Smartsheet34Daniel William Maycock
I have a number of Harvey ball metrics (count of red, yellow, green tasks) and things that change every day. I haven't really seen any way to capture and store these each day at a particular time (or hourly, weekly, monthly). Anyone have a…
Formulas and Functions4Ezra
Has there been any progress with adding card view to reports? Has this been an approved feature and scheduled for a release? Our company has been pushing a move to JIRA because of the gap with smartsheet in allowing our teams to vi…
Using Smartsheet591Jess Evers
Thought I would start my own thread regarding this since it seems very quiet around this change.
Am I the only one having no luck in using the suggested shortcut CTRL ] to indent?
I am using Windows 10, Chrome webbrowser and swedish keyb…
I set up indefinitely recurring update requests. Currently, I have to manually delete the update request when I receive the requested information. Is there a way to automate turning off a recurring reminder? For example, if I have a &qu…
Using Smartsheet16Kevin Minkoff
I want to use smartsheet as an international project management tool. One thing is driving me creasy.
I want to send out a notification to an assignee if the predecessor task is completed. Please find attached a screenshot of my scenario.…
Formulas and Functions213Alexander Wirtz
Hey @Paul Newcome / @Andrée Starå ,
Well if you dont mind helping, i'll ask another question :-) Started a new thread for others that might want to see it as a separate request.
In a nutshell, at the parent level, I'd like the "curr…
Formulas and Functions23Dyon Martin
Not really a question. More of constructive criticism/asking for better developed features.
I use Smartsheet as a scheduling tool at our company, We use master project sheets and a series of project reports and company reports. We generall…
Using Smartsheet18Jonah B @ Job Shop
Hello! I am working on a sheet with Start/Finish dates and need to populate status' into the following 4 categories: not started, in progress, complete, up next
For not started/in progress/complete i have the following formula working:
Formulas and Functions33Emma Schachter
I am using Smartsheet and I am involve in 3 projects and all are main and lead roles. I made 3 separate sheets for each project but I realize each projects affect the other projects and then sometimes the predecessor is in another sh…
I'm new to using SmartSheets and first time poster here. Hoping you can help me with an elegant solve? I'm trying to create a function where a row will be highlighted when it satisfies two criterias:
1. if the date created has bee…
Formulas and Functions86yheng
I am building a change control log. Is it possible to pre-populate a form with cell data from a sheet? For example, project name, ID, customer, description and resource from the sheet to help the process of logging a change to the change c…
I've seen similar requests on these forums but unfortunately I have not yet been able to make this work.
I have a project schedule with Start Date and End Date columns. My leadership would like to see two associated columns tha…
Formulas and Functions151Matt.Robinson
I would like to to set both Task A and Task B as predecessors of Task C. A and B end date would determine the start date of Task C through Finish to Start dependencies.
However, Task A and B can run in parallel (no dependenc…
Formulas and Functions25Alessandro Terranova
I'm trying to create a form that is dynamic wherein the other fields will changed when a certain category is picked.
For example, selecting category: printing project that will have how many pages, if it's double sided and what ty…
I am launching a new project with 13 working groups and many dependencies. Do one of these template sets function better under these parameters?
Using Smartsheet44Paige Luben
OK sleuths, this one is for you. We are an organization that loves powerpoint, and no matter what dashboards we create, a powerpoint presentation is typically still needed. We need a way to consolidate our project status in one easy docum…
Premium Apps and Integrations384Tana Perkins
I use this function, TODAY(), to calculate days to an event or past said event.
I've noticed that you have to open the sheet to update or probably more accurately get the TODAY function to be active and calculate.
I use this day counts i…
Formulas and Functions295DanielGD
Hi, Community! I am wondering if anyone else is using SmartSheet for an institutional planning calendar. I chose a template of project with gantt. Most of the tasks on the calendar, however, are annual, bi-annual, semi-annual, etc. I am tr…
Using Smartsheet55Mary Vogt
Any idea when or if we will see Card View on Reports in the near future? If not, I'd like to add my vote for this feature as soon as possible; it would be very useful to our workflow. Thanks.
Using Smartsheet130Colin Entrekin