-
Tracking Data / Shared Sheet
Hi! I'm really enjoying Smartsheet and glad we decided to go down the path of subscribing. While I was getting certified I found so many neat features and my mind just filled with all the things I could probably use various aspects of Smartsheet to accomplish. I ran into a limitation in my own scope that I'm sure…
-
Turning flag red with conditional formatting
Is it possible to turn a flag red using conditional formatting? I can turn the cell background red (or any other color), but not just the flag.
-
Salesforce ServiceCloud Users/Connections
Hi Smartsheet Community, We're thinking of some use cases for helping Smartsheet users utilize Salesforce ServiceCloud data more effectively and efficiently. Any Salesforce ServiceCloud users out there who would be willing to chat with us and give us feedback on our use cases? Even if you don't use ServiceCloud but know…
-
Turn average working days to projected date using WORKDAY()
The basic ask is to calculate a projected due date based on historical data and duration that a certain task takes. So if x, y, and z parameters are checked, it will find the average amount of time (from a different sheet) that those parameters take and then calculate a suggested due date. I want to use WORKDAY(), but am…
-
Yellow rows.....
Can someone help me understand the why the yellow colored rows are showing up? And how to fix it? I think it has something to do with dates but cant seem to figure it out. See the attached screen shot. Thanks much.
-
Problems with Levels in Card View Mobile
Hello! Does anyone else have issues with Levels in Card View on mobile (Android)? It appears that the Level view gets reset when leaving sheet -- and even worse, If I set the display to "Level 1 and subtasks", and then I add a subtask, it will switch the display to "Level 2"! (and all my main tasks will disappear). I was…
-
holiday period
Hello, I'm trying to add holiday (complete shut down for 2 weeks) period to my project sheet. I've done it in project settings ect. but it is not showing on my sheet. The project should be that much longer and I was expecting to have a separate bar to appear showing holiday period cutting all tasks started and putting them…
-
SUMIFS in a Dashboard or Report that references another sheet
Hello! I'm looking to utilize a Dashboard or Report and can't, for the life of me, figure out the best way to do this. I need to give a summary of units sold to a customer, per product type, per year. See attached screenshot. Questions or need additional information, just let me know. Thanks, Matt
-
Import and Export Conditional Formatting Rules
The possibility of being able to clone rules across sheets has been mentioned before in a couple of posts, but I want to raise the issue again because of an incident that occurred last Friday. A key Smartsheet with over 100 conditional formatting rules (123 I believe, according to the Activity log) lost them all. Hopefully…
-
Formula for auto flag
I am trying to create an auto flag on a project that says if % complete is <= 80% and the end date is <= 7 days from today then flag. Here is what I have so far =if([% complete]<=0.8,0.5,0)+if([end date] - today()<=7,0.5.0). It turns the flag red when it falls into the not 80% complete in the time frame but when there…
