-
Automatically enter certain Text in a cell if Date Open > 60 days
I 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 the text that is in the reference cell. It works fine but it relies on me copying and…
-
Pivot tables grouping
In excel you can group pivot table rows by days under the "PivotTable Analyze" tab. Does Smartsheet have the same functionality?
-
Embedded IF(AND(OR Function Help
Hello, 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 that all three columns read either "Complete" or "Not required". I've tried to do this by embedding an "OR"…
-
Workflow automation for when a cell in a column does not change status
Trying 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 nothing for when a column doesn't change. Any suggestions?
-
Count dates within a specific range
I 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 cells contain dates within a specific range. I'd like to count cells containing dates…
-
Assistance w/ automated Checkbox based on multiple conditions
Hi 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 contact" is populated. Column "Quantity" is populated. Column "Product" contains the word "Device" Then a sum is used…
-
How to count checkboxes-checked, between Nov 1st, 2020 and December 1st, 2020
I 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), COUNTIFS({Tuning Release Date Range}, >= A11, {Tuning Release Date Range}, <= A12) I…
-
Count how many jobs start in a month
I 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}, ="", {Tippa Start}, MONTH({Tippa Start}) = MONTH(TODAY())) Then I try and modify it to the…
-
#UNPARSEABLE using COUNTIF for text objects
I have a Form which allows the recipient to answer a question via a drop down list: Example: Where would you like to go for vacation? List includes: U.S., Europe, Asia, Australia It's a pick many list so users can select any number of answers. The resulting cell then may contain something like: U.S. Europe Asia I would…
-
Converting a formula to a "column formula"
I am trying to convert this formula into a column formula. It takes selected cells from a row to populate the overall "Status" column. If tasks are "Not Started", the overall status will be "Not Started". The Same would apply for Cancelled. If all tasks are complete, cancelled or n/a, the overall status would be "n/a". If…