Conditional Formatting
Discussion List
-
Pivot tables groupingIn Apps, Integrations, and Add OnsIn excel you can group pivot table rows by days under the "PivotTable Analyze" tab. Does Smartsheet have the same functionality?Answered - Pending Review 51 views 3 comments 0 points Most recent by Genevieve P. Apps, Integrations, and Add Ons
-
Embedded IF(AND(OR Function HelpIn Formulas and FunctionsHello, I have three columns in my sheet each with dropdowns including a "Complete" - type answer and a "Not Required". In the fourth column, I am trying to write a formula to show when the row is 'good to go' - such th…
-
Workflow automation for when a cell in a column does not change statusIn Formulas and FunctionsTrying to see if there is a work around for setting up a workflow automation to trigger when a status column does NOT changes status from planning to in progress after 14 days. I only see triggers for when a column or row has changed, but…
-
Count dates within a specific rangeIn Formulas and FunctionsI am collecting performance data for my project. I have a report that contains all of the data I want to analyze and report statistics on. I'd like to look through a column containing dates including some empty cells, and count how many ce…Answered - Pending Review 21 views 5 comments 0 points Most recent by Paul Newcome Formulas and Functions
-
Assistance w/ automated Checkbox based on multiple conditionsIn Using SmartsheetHi All, I'm after some assistance regarding a formula to automate a checkbox based on multiple conditions. These are; Column "Requested by" is populated with a date. Column "Site" is populated. Column "Site contac…
-
How to count checkboxes-checked, between Nov 1st, 2020 and December 1st, 2020In Formulas and FunctionsI am looking for help creating a formula that works with the above question. I will replicate it for each month through one fiscal year timeline. Currently I have this formula which results in UNPARSEABLE. =COUNTIF({Data Range 3X}, true),…
-
Count how many jobs start in a monthIn Formulas and FunctionsI am trying to create a formula that counts how many jobs are due to start in a month, that havent already been started. I have created the below formula to try and count the jobs in the current month: =COUNTIFS({Tippa JC Status}, ="…
-
How can we have a drop down in DashboardIn Using SmartsheetHi Team, How can we have a drop down in Dashboard My objective is - Say for a example a user want to see just the input related to his/her project he can filter his project from dashboard and view. ThanksAnswered - Pending Review 99 views 2 comments 0 points Most recent by Finops C'ship Using Smartsheet
-
Workaround for VotingIn Using SmartsheetHello, From other community questions I see that there is no voting functionality in Smartsheet but I am looking for a workaround. The use case is to have a system for internal enhancement requests to our ERP. Internal employees would have…
-
Conditional Drop-down list columnsIn Formulas and FunctionsHey Is it possible to have the the drop-down list of a column changed based on the value of another column? Eg. If column A's value is set to "Work stage 2" column B's drop-down list will have a specific list, but when it is se…
