Conditional Formatting
Discussion List
-
How to input a date/time and calculate a time elapsed?In Using SmartsheetI'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 el…
-
Integrate with Outlook with Dates and Times and Assignee InformationIn Apps, Integrations, and Add OnsThe outlook integration as it exists is nice if you only have one or two projects. As a single user I manage hundreds of projects at a time I would like to be able to sync my calendar to outlook in a more integrated format. For example,…
-
Automatically Track Inventory UsageIn Formulas and FunctionsI'm new to smartsheets and am not an excel expert, but I've been building some sheets and workflows and have a question about more advanced capabilities of the program. I'm hoping there's a way to automatically track inventory usage base…
-
Total Cost Based on Date of Task Being FinishedIn Formulas and FunctionsI am working on charting out dev tasks and need to display what our expected total monthly cost would be based on the tasks finished each month. I am struggling to find out a good way to have this either permanently displayed or easily acc…
-
How do I apply conditional formatting to a single cell?In Using SmartsheetHello, How do I apply conditional formatting to a specific cell? For the example below, when I click on the "B/C" check box, I only want to highlight the B/C within that row and not that column. Wasn't sure of the best way to …Answered - Pending Review 613 views 4 comments 0 points Most recent by Hannah Mills Using Smartsheet
-
Trying to Auto-update due dates based on actual completion dateIn Using SmartsheetHi, I am new to smartsheet and I am finding it very useful; except that I can't figure out how to auto-update completion dates. For example, when I plan out my project, I put start dates, duration, predecessors and who it's assigned …
-
Forms Workaround: Submit button opens new form to allow sub-info - How do I stop when user is done?In Using SmartsheetPlease help! I'm stuck. Goal: Create a form customers can use to report a problem with an order. The order may have more than one line item (i.e. Customer ordered 5 received 3 of product #1-ABC and ordered 3 and received 5 of product #1-…Answered - Pending Review 55 views 3 comments 0 points Most recent by Teresa Durham Using Smartsheet
-
Conditional Formatting - multiple columnsIn Using SmartsheetHi All, Hope you are all safe. Is it possible to apply conditional formatting to multiple columns (same condition). I have data in 10 columns. I want to highlight cells where the value is not equal to 0. Currently I have to apply condition…
-
Hiding form drop downs based on prior submissionsIn Formulas and FunctionsI'm trying to mimic a Qualtrics survey capability that enables the survey (form) to only show available dates that have not already been selected by prior survey respondents. Is there a way to accomplish this?Answered - Pending Review 22 views 1 comment 0 points Most recent by Bassam Khalil Formulas and Functions
-
Automatically enter certain Text in a cell if Date Open > 60 daysIn Formulas and FunctionsI currently have 2 formulas that work in conjunction to look at Acct Open Date and if it's greater than 60 days it populates a column/cell with yes or no (via checkbox) then, looks to a SECOND column/cell and tells the first cell to enter …
