-
How to use Smartsheet to track and record appointments and events: third party app solution?
Hi, I am using smartsheet to enable a team of folks to collaborate on project managment. Our projects are organized into objectives, activities and events - each getting its own row and set of data for timeline management, allocating human resources, tracking deliverables, etc. Our team uses google calendar to schedule…
-
Row properties
Is there a way to apply "row properties", similar to "column properties"? I have an analysis that has customer listed across the top and the rows are the critieria with which they are being evaluated. I'd rather scroll down than across.
-
Row Sorting
I am trying to sort a smartsheet where I have some rows at the top that are used for calculations and formulas, so I only want to sort certain rows not all of them. Is there a way to do this? I tried locking those rows but that doesn't work, and I tried just highlighting just the rows I want sorted (similar to how it works…
-
New Row notifications via Send option
I want to use the "Send" option to send an email to the user each time a new row is entered, automatically. I have used the Notication Alert but it accumulates the rows in the same email.
-
Symbols not changing based on the value in another cell.
I entered: =IF(%3 > "0%", "Red", IF(%3 > "50%", "Yellow", IF(%3 > "85%", "Green"))) and all the cells are red. Not sure why the formula is wrong! . The icon is in the column "Indicator" and the value is in the column "%". Any help much appreciated
-
If Status "Complete" how can I set it to automatically update the color on the RYGG balls?
We would like to do conditional formatting or a function so that when the Status column is marked 'complete', it will automatically update the RYGG Ball color in the column next to it. Does anyone know how to do this?
-
Duration calculation issue
I don't know if it is bug or feature, but it looks strange for me. So I have sheet created based on project template. I have dependency turned on. I noticed next behaviour: If task start at weekend or holiday then duration calculated with one extra day. On attached image all tasks (except task2) have wrong value in…
-
Screen auto refresh
My work is set up with a dual monitor and I normmaly have Smartsheet opened on both of my monitors. Since the upgrade a few weeks ago, I have noticed that the screen will auto refresh or even sometimes while I am typing it will automatically refresh itself to match the other screen. Is anyone else experiencing the same…
-
Scheduled email based on a condition - Request
First off, having scheduled email across the entire platform would be a godsend on its own. Such as from a report. This way i can have only the information i want them to see is sent. Secondly, sending an email based on a condition. Basic example, if a box is check, send the email at such dy and time. Is there a better or…
-
Calculating date due for Service Level Agreement
I have a date assigned column which would be the date someone entered a case. I'd like to automatically calculate in a due date column the 5 day SLA date, accounting for weekend days. Is there an easy formula for this?
