-
Visual budget management
Hello, I'm working on a total overview of projects in a sheet, using different columns with start and end dates and with budget reserved en budget spend. The thing is that I would like to compare the budget reserved with the budget spend. So that when the budget spend is higher then the budget reserved it changes color. I…
-
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
-
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…
-
Formula to create a Symbol response based upon a text string in the Comment
I am attaching from my emails a specific email response to the comments. The email will always have the same email the address is from. I would like to create a column using a symbol and say..... If the following text string is listed in any comment related to that record and to show a green dot.
-
Nested IF statement - with checkboxes
I am looking for an IF statement to check the box if true, but do not check the box if NOT true. =IF([Actual Response Date]47 <= [Response Due Date]47, 1, IF((ISBLANK[Actual Response Date]47), " ")) I have an Actual response date, so when the date is over the due date OR is blank, I do not want the checkbox to have a…
-
Creating an Alert for Attachments
I'm using a Form to collect data that is populated in Smartsheet, and the form asks each user to include an attachment with their submission. I'd like to be able to mandate that the form cannot be submitted without an attachment OR set up an auto-notification to the user submitting the form to submit an attachment if that…
-
Identify all cells that contain a formula?
I'm trying to look at all my formulas and am wondering if anyone knows of a way to (temporarily) highlight or identify every cell in a sheet that has any kind of formula in it.
-
Smart Sheet Freelancer Required
Seeking an independent Smart Sheet Consultant to begin work no later that the 31st October 2017 6:00 PM GMT You should be able to screen share and use our already uploaded excel spread sheets to create reports.and sights. You should be able to use the advanced functions of cell linking and formula to create forecasts.…
-
Form Reminder
Is there a way to set up a daily reminder via a web form without having to share a sheet with the individuals who will be completing the web form? Scenario: I have a report that needs to be ran daily by a dept. outside of my office. The report should be ran each morning for the data from the day prior. I created a web form…
-
Auto-populate a value based on dropdown
I am trying to have a column with dropdown choices auto-populate a value in the next column. If IP-A is chosen in the AssetType column, the TotalHours column should display 1. If IP-D is chosen the TotalHours should display 15. I was thinking conditional formatting would work but it only formats text/background. Is this…
