-
Using COUNTIFS to count specific words
I have a sheet with a multi-select containing topics such as: Age, Disability, Wage-Hour, Sex, Sexual Harassment, Sexual Orientation, and other unique values. I am using this formula: =COUNTIFS({Drop1}, CONTAINS(Claim@row, @cell), {Month}, 1) to count specific instances by month and it works except for Age and Sex because…
-
Summing cells with text and checkbox
Hello, I am looking for a formula to add cells that include both text and a checkbox. Please see example below. If Request Type is "FSA" and the box under "Backlog" is checked, formula return a "1". Similarly, if Request Type is "Warranty" and the box under "Backlog" is checked, the formula returns a "1". Thanks again for…
-
Formula to Cut and paste Last 5 Digits into another cell
Hi there, Is there a way to Cut and paste Last 5 Digits into another cell? Example A1 has: 12345678, can I cut 45678 and paste into B1, using the same formula, for the entire column ? (I know about the remove first or last digits, but is there a way to cut and paste?) Thank you for your help!
-
Display negative for past days and positive for upcoming days
I've got a sheet with a "Start" column and a "Today" column. I want this formula; =NETDAYS(Start25, TODAY25) To display the number of days as a negative if the Start was prior to TODAY or as a positive if the Start is after TODAY. Currently, my displayed results are opposite to that.
-
IF/OR Statement
Good morning everyone, first of all, thank you to this community, you have all been a huge help, as someone who had very limited excel/smartsheet skills, this community has helped a lot! My organization has several departments and in our office one individual is responsible per department. Although long, my formula looks…
-
If/And/Or formula help, please!
Hi there, I've been playing around with an if/and/or formula but I can't get it to work. Can someone please review my formula and tell me what I'm doing wrong? What the formula should do is to indicate "Yes" if status of row X and row Y is any combination of "Yes" or "N/A". If there is a "No" in any either of those rows,…
-
IF Statement w/Drop-down Multi-select
Hi folks, I'm trying to create a formula focused on two columns (one a single-select drop-down and the second a multi-select drop-down). Based on the value in the single-select drop-down, I'd like the multi-select column to include multiple selections. My attempt at the formula is below: =IF([Change Requested]@row = "New…
-
Combinations of seperate checkbox in rows activating a single count
Hello team! I am trying to categorize 4 different types of work and then also capture how much of each type of work we are approved for. I have four seperate columns of check boxes for different types of work and then a fifth for if the work is approved. the rows have the specific data for the specific work. How can I…
-
Report Total Number of Times a Cell was Modified
Hi Smartsheet Community! I need to be able to report on the total number of times one specific date field has been revised over the course of the project life cycle for trending purposes. I like that we have the ability to view the cell history by right clicking on the cell itself, but it would be nice if there was a way…
-
How do I set up "TODAY" and (-365) days and a NOT completed function for a metric sheet?
I am trying to set up a metric sheet to be used in a dashboard that I am creating. I want to show a count of all task that are not marked as completed with a due date of current day and back, up to 365 days, but I am receiving an #INCORRECT ARGUMENT error message. The function command I am using is: =COUNTIF((NOT({1.…
