-
CountIfs one column is not blank and the other one is
I'm trying to count rows that have a date in one cell but is blank (no checkmark) in the other. Is that possible? I've done multiple iterations, all unsuccessfully. Here's the last one I've tried: =COUNTIFS([Date Tip Sheet Submitted]1:[Date Tip Sheet Submitted]1129,<>, [Tip Sheet Archived - No longer relevant]1:[Tip Sheet…
-
Index A Pivot Table
Does anyone have experience using Index on a pivot table? Or perhaps there is a better way. We use a pivot table to summarize various stages of the sales process (not contacted, needs contact, active priority, hot needs call, warm needs call, etc). I need to pull the summary numbers from that pivot table each week into a…
-
Using several conditions
I am trying to build several conditions into my Smartsheet, is there a limit as to how many we can have? This is the conditions I need to have set: GRAY - when renewal status column status are selected: Awaiting Information, Bound (Lead), Bound (Subscription), Broker Contacted, Cancelled, Extension, Lapsed, Lapsed - Final…
-
List Based on Date
Hello, I have a sheet with multiple columns. 2 of those columns are "Name" & "Date". If the date is older than 14 days, I would like to get a list from the Names as well as the Date. I don't need any of the other data from the other columns. Just a list with the names and dates of anything older than 14 days. Thanks
-
Countifs with age ranges
Hi. I'm trying to write formula where the age range is 10>= and <=19 yrs old. Here's my formula: =IFERROR(COUNTIFS({OHCA Form - Agency}, $Agency@row, {OHCA Form - Review Complete}, "Medical Review Complete", {2021 OHCA Form - Etiology}, <>"Trauma", {OHCA Form - Incident Date}, ISDATE(@cell), {OHCA Form - Incident Date},…
-
Formula to Check a box at different indention levels
Hey there, Trying to figure out a formula to automatically check the boxes based on how many times a task has been indented, like this: I know I can set the Activity column to: =IF(COUNT(CHILDREN([Task Name]@row)) = 0, 1), but I don't know how to do the others. Any help would be appreciated!
-
Formula to return a 1 if cell is between two weeks
I just started with Smartsheet 10 days ago and I just want to say this community is great! Up until now I've found the answer for every question I had on this forum. I'm trying to get DueNext2 to return a 1 if the Due column is within two weeks from today. It isn't working and I've tried everything I know (which is very…
-
Is it possible to change the wording on the "Open Update Form" button?
Is it possible to change wording on the "Open Update Form" button?
-
Need help with an IF statement / Add 50% to formula result
Hello, I've wrecked my brain trying to figure out the formula just to add 50% to the returned value. I got close but it seems to be off by a few dollars. I also will need to use this in an IF formula. If Express Check = N then =SUM[Column2]@row - 5000) * 0.64 + 11002.5 total is 11017.86 My formula =SUM([Column2]@row -…
-
Creating a Date range
I am trying to create a date range and keep getting an error. I would appreciate assistance. Thank you =COUNTIFS([Business Unit]:[Business Unit], "CAI Business", Status:Status, "In Progress", (AND [Start Date]:[Start Date] >4 / 1 / 21, [Start Date]:[Start Date]<06/30/21))