-
Highlight Changes
Hello, I want to know when information has been updated in a sheet, how do I set this up so any changes made in the last X days highlight the cells? Thanks, Hannah
-
One off Saturdays in Gantt
Hi all, I work in construction and use the gantt chart heavily to manage scheduling subs. I have a unique situation for my project where I may have to schedule work on a Saturday. Is there any way to allow a single Saturday, instead of opening Saturdays for the duration of project?
-
Enhancement Request: Ability to lock a row if if a task is dependent upon another being completed
Example: There are Task 1 and 2 and Task 2 has Task 1 as Predecessor task. Until Task 1 is marked completed, Task 2 or some of its columns are LOCKED and cannot be edited.
-
Form required fields - preventing form submission?
Hello! I'm wondering if anyone knows of a way to prevent a form from being submitted with empty required fields. Let me know what you know! I'm hoping there is a way to do this. Otherwise, this doesn't feel like they are truly required. Just strongly suggested. :) Thank you so much in advance for any guidance or knowledge…
-
Continuously evolving Sum formula
Is it possible to create a formula or workflow that would move/update our "90 Day total" column as new months come and go? I've attached what we are currently working with. The 90 Day Total is just a sum formula for each Jun Jul and Aug. The rest of the year is mapped in the exact same style, but for Sep Oct Nov and Dec.…
-
How to input a date/time and calculate a time elapsed?
I'm brand-spanking new to Smartsheet. We are trialing it for work and I'm trying to convert some of my Excel workbooks for use in this new platform. A really common formula for my work is =(Time1-Time2)*1440 which gives me a total time elapsed in minutes. I then build my dashboards to take those calculated fields and do…
-
Formula not working
Hi , Can anyone help me with this formula issue:- I have 4 symbol color- Not Started- Gray Not Applicable- No color On Hold -Yellow Complete- Green Act1 greater than Act2 and Status is equal to In Progress - Red else Green =IF( Status@row <> "Not Applicable", IF( Status@row = "Not Started", "Gray", IF(Status@row = "On…
-
Return status of cell (blank vs. full) at today's date.
Hello! I am trying to use a function that will tell me whether a cell is vacant or full at today's date. We are trying to create a desk booking system for our office, so the end-goal would be to have a vacant/occupied indicator on a SS dashboard. My test sheet is below: So, to determine whether Desk 1 is occupied or…
-
Smartsheet data connection in TIBCO Spotfire server
I am able to create an ODBC connection and get smartsheet data in my Spotfire Analyst client. I followed this link - https://smartsheet-platform.github.io/odbc-docs/#tibco-spotfire-desktop. However, I would like to create an information link and publish data in Spotfire library and share the web link with the users. The…
-
Extract Image using Index and Match/Vlookup
Hey All - Does this exist yet? See screenshots below. Am i missing a piece in the formula? Or is my column type incorrect? I cant seem to find an article on this. I know its a bit tricky to do this in excel too - and their version doesn't work in SS. Additionally, I cannot do a direct link, because we are using the "store…