-
WBS Overdue status trigger points
Hi, I would like to look at setting up a formula that shows if a WBS status is either overdue (symbol would be ! High) or has say 5 days to go on the WBS and is only sitting at 60% completed (symbol would be - Medium). The trigger point would have to be driven off the :Finish" date in the setup screen shot. The colums…
-
Set Up Conditional Formatting to Enter Current Date
I'm fairly new to setting up my own SmartSheet pages and was wondering if this would even be possible. Is there a way to link a Date column to a check box or a drop down item? For example- I want to have it so that when a certain item is selected from the Dropdown list, a Date column would auto-populate with the current…
-
Schedule automatic reports for updates
I have project teams of 10-20 people and each are assigned tasks. On a weekly basis, I want to auto-gen a user-specific report of their task items and send a request for updates on all items. For example, every Tues at 11 am, I'd like to have a report generate that contains all assigned items where the % Done is less than…
-
Advice on Simplifying formulas
https://app.smartsheet.com/b/publish?EQBCT=3ae72b85648c4e968b5320160bb7e3c6 This sheet checks the net time machines were down, or work was done on a line item by using a date modified column and a date created column. The formula is rather complex, and I am not going to have the time to teach anyone how to edit it (they…
-
Uploading large excel sheet
Yes, I read the blog posts from 2016/2017. I tried loading a sheet with 32 columns and received an error message indicating I had over 200 columns. In my opinion, the error message is misleading. Submitted this to SmartSheet support. Just wondering if anyone else is having an issue of this nature.
-
How often does a report update?
We are using a Smartsheet Report to upload data into a third party system. We are curious as to how often the Report will update. Example: If we open one of the Smartsheets that feed the Report and make a change and we do not open the Report, then when the third party system pulls data from that Report, will it have the…
-
Report - Finish Dates
I have a report I use which gives me all tasks in my projects that are overdue, due today, or due tomorrow. (A screenshot of the report builder is attached, below.) It stopped working properly yesterday, when I updated some dates but the task did not drop from the report. Today, it's showing tasks that are due a week from…
-
Is there a way to improve identification of a found card when searching?
So, if you do a search in card view, the line around the card is barely changed to identify the card searched for. I added a SS Enhancement request to improve this but wondered if anyone had a suggestion other than searching list view? Thanks
-
Reports showing wrong criteria
Hi I have been using reports for a while now and everything has been working fine however lately they have been including results that do not meet the criteria I have specified. For example I have a report that's criteria is Column 1 is Yes and Column 2 in not checked that they will appear on the report. However lately the…
-
Automating Project Status
Hello, I would like Smartsheet to automatically assign a project status based on duration and number of days behind project. I have specifically been asked to assign a project status of red if the task is 20% behind schedule. Please let me know if you are aware of how to automate this in SS. Thanks in advance for your…