-
Need Summary Sheet formula to count age in weeks of assignment
I have a column which is the Assigned Date of a task. I use this formula in the summary sheet to count how many items are a week old from todays date: =COUNTIF([Assigned Date]:[Assigned Date], What would the formulas be to count assignments that are 2 weeks old, 3 weeks old, 4 weeks old, etc.
-
90 Days Prior to a Target Date Formula
Hi There, I've reviewed the forms and found a formula that seems to work for everyone but me: =[Target Submit for Comment Date]@row - 90 I get Invalid Column Value error. I just need to calculate 90 days before a specific date - how would I go about doing that? Thanks!
-
Need a column to have sequential numbering even when rows are moved around
Hello! I have a column that needs to have a list of numbers that stay consistent even when rows are moved around. So if row 3 was drug up one the primary column values are x, z, y, but column 2 would still be 1, 2, 3. Thanks in advance!
-
Converting seconds to dd:hh:mm:ss
I am trying to import a report from Service Now that shows how long it took for a ticket to close. The duration field from Service now to excel export is in seconds. I need a field that would show the duration in days, hours, minutes. Service now has a formula for excel but I am having trouble converting it into…
-
Formula help
Hey guys, I need help to put a formula in my sheet that can sum all 'Type A' column that are from a specific campaign and specific market delivered in a specific month. so all type A, from Jazz AT, in April. Thanks in advance Katie
-
Count rows in sheet for dashboard metrics
I'm a little stuck! I have a sheet that is for Dashboard Metrics and I want to count all the rows in three different sheets to add to my dashboard. Each sheet contains different contacts so I want to show how many contacts are in the different sheets...what formula can I use on my dashboard metrics sheet to count the…
-
Changing Duration cell based on specific dropdown from Status at row
Hello, I'm trying to create some type of function that performs the following: Status dropdown has "Not Started, In Progress, Complete, Exempt" Status at row is selected as "Exempt" When status at row is "Exempt", the duration at row will change to 0 My goal is when someone selects the "Exempt" option in the status…
-
IF cross-sheet formulas with conditions
I'm working in a sheet column and trying to pull data from another sheet BUT pull data from two different columns based on IF this row matches data in another column. Here's the current formula that only pulls "Schedule Notes" from another sheet when it matches the Course Numbers. =IFERROR(INDEX({Course List Worksheet -…
-
Why is the formula saying invalid operation?
I have a Smartsheet page that I am trying to pull data from between 2 dates. The formula below is the one I am using but it says invalid operation? =SUMIFS({Work In Progress - 2021 - Range 3}, =[Primary Column]@row, {Work In Progress - 2021 - Job Value Range 3}, {Work In Progress - Job Value Range 1}, <=DATE(2024, 3, 31),…
-
Help with Countif / Countifs formula
I am trying to count values from a column that is a dropdown/allow multiples column. For example, there are three dropdown options to choose from - red, green, blue. Cells will have one or more dropdown items selected. I need to count all cells that have red selected (regardless of the other choices). THat is, the number…