-
How to analyse/illustrate slippage of tasks in Smartsheet
Hi, I would like to get my sheets to highlight tasks which are overdue for completion in Smartsheet, and any subsequent tasks which may slip as a result. I imagine I will need to do a formula for this would be grateful for any advice on how to do this. Thanks
-
Using formula - Pick first day of the week
For example, today is 11/15, and first of the day (Monday) of this week is 11/13. How can I pick up 11/13? Thanks for your advice!
-
Has anyone used Tempus by Prosymmetry?
My Smartsheet contact had recommended Prosymmetry to me for my companies resourcing and time tracking needs, and I'm doing due diligence and vetting. Can't find much information on this company including their seed funding or VC info. Has anyone else used this tool? What has your experience been?
-
DSN architecture mismatch
When I try to follow the ODBC instructions for the 64 bit Live Data Connector to use it with Microsoft Excel or Access 2016 and the Smartsheet DSN I set up in Windows 10 using an API access token, I get the following error: [Microsoft][ODBC Driver Manager] The specified DSN contains an architecture mismatch between the…
-
Gantt Chart Due Date Flag / Milestone
Hi, Is it possible to show a 'flag / milestone' as well as the duration bar on one line of data. I would like to have a due date associated with a task, as well as a duration. Such that I can see instantly how close I am to a due date. Thanks
-
Number of rows in a sight.
I have a sheet with just under 500 rows, with information about buildings. I have a report to format a concise list of information to publish, and have several widgets, including links to the maps that have some of the source data, on my sight. The Sight only displays the first 150 buildings, with a pop-up link to the…
-
Need a way to calculate hours and minutes
We are using the hours and minutes duration option for our projects and need a way to calculate the stop time based on the duration. We enter the duration and Start Time and want Smartsheet to calculate the stop time (currently we have to enter it manually and there is definitely margin for error... not to mention time…
-
Summary Status on Parent Row
Hi - My apologies if the answer is somewhere in the community but I can't seem to find it. I have a project sheet and in it, I have a (RYG) status column. I would like a status symbol to appear in the parent rows. How do I achieve this? I've attached a small screen capture to illustrate where I would like the status ball…
-
Project Management - IF(OR(AND())) - Formula Help
I've been working on this for some time and just can't seem to get it to work the way I need it to. I am attempting to build one sheet that will allow me to track the status of all the projects in my section, while also tracking the progress of tasks within each project, for both current and historical projects. I have…
-
Reminders in templates
Good morning, When I create a template the reminders do not transfer. Am I doing something wrong? The reminders are in the original sheet that I use to create the template. Thank you! Susana
