-
conditional formatting not working
I'm trying to make my conditional formatting work so that a column is highlighted a specific color is the % Completed column is over a certain amount and the Due Date is in the next 7 days. I even moved this rule close to the top of the list, just to make sure this would work. Can anyone help me fix this?
-
One Project - Multiple Clients
I have one project where certain tasks are paid by one client and the remaining paid by a another. Example: Data collection paid by Client A, Data Cleaning paid by Client B How would I set this up so when the smartsheet project is linked to resource managment the allocations are assigned to the correct client /budgets?
-
Import Outlook Calendar into Smartsheet
I was wondering if this is possible yet, or if there have been any updates? https://community.smartsheet.com/discussion/how-import-outlook-calendar-smartsheet Importing from Smartsheet into Outlook is nice, but I would love to have a 2-way possibility. I have a lot of projects going on all at once, trying to keep up with…
-
Using SmartSheet for Discussions/Messages/Threads
Hello! We've been using SmartSheet for the last ~9 months and love many of its features (e.g. project plans, Risk, Actions, and Issue Logs, etc). One use case that we haven't been able to find a great solution for, however, is basecamp like message boards/discussions (https://basecamp.com/features#message-boards). How have…
-
Conditional Formatting using a custom formula?
Hi there, So I'm trying to set up conditional formatting to visually alert us if 3 days go by and we haven't followed up with someone. My idea is to make an "Estimate Sent" cell which records the date we sent an estimate and turn it red if we haven't checked the "Estimate Approved" column after 3 days go by from the date…
-
University Permit or Special Event Request From
Hello, I am wondering if anyone in this group uses Smartsheet for Permit or Special Event applications? We are looking to utilize Smartsheet to streamline our Alcohol Permit process and I wanted to see if anyone is already using Smartsheet for something similar. Thank you in advance!
-
Design Question
I have taken over management of our sheets for my department and have been trying to redesign them to make them more fluid, functional and all around nicer and implement it at the start of the year. We use Smartsheets for construction projects. We maintain a bid list of all projects bidding and ones that have bid during…
-
The behavior of Duration, Start Date, and End Date fields when dependencies are enabled
Thought sharing what I learned about editing these fields in a sheet vs a report could be helpful to others. Please note that this only applies when dependencies are enabled on the project settings. On the sheet when they are all blank, indicate any 2 and Smartsheet calculates the third After there's already data on these…
-
Formula to add "No" to a blank cell, but leave value if not blank
On a Smartsheet project intake form, I have several Yes or No dropdown selections. If Yes, the user must answer additional questions. If No, they do not and those cells are left blank. Auditors do not like Blank cells, so I'm looking for a formula to replace those blank cells with "Does Not Apply" but leave a value there…
-
Calculate the time between two dates by days, hours and minutes
Hi, I am trying to implement the following formula from my excel spreadsheet into my smartsheet: =INT(O2-Q2)&" Days "&HOUR(MOD(O2-Q2,1))&" Hour "&MINUTE(MOD(O2-Q2,1))&" Minutes" Basically, i need to calculate the time between two columns (date received) and (date documents issued) in days, hours and minutes. Cell 'O2'…