-
Formula - Add "Blank" as a value in IF formula
Hi Smarties, I know this is probably an easy one, but I have been cracking my head over the last 2 days so here I am! I have 4 columns representing Task 1 to Task 4. Each column has a single Drop-Down with Not Yet Started, In Progress and Completed. On the column Health, I have symbols of Red, Yellow and Green. Basically,…
-
SUMIFS - Formula correct but not working in Sheet Summary
I'm trying to add a Sheet Summary that will look sum cell with $ based on 2 other criteria in drop down columns. It won't return any data: FORMULA: =SUMIFS(Estimated Rev $:Estimated Rev $, Probability:Probability,"P10", Business:Business, "Spare Sales") Estimated Rev $: Free Text Field range from 0 and greater Probability:…
-
Need to report on date and category
I have a table for help desk tickets. Among other things, we capture the closed date , category, and "rolled category". I need a monthly report that will tell me for each of the last 13 months, how many tickets were closed for each of the "rolled categories."
-
Notification Automation not working
I have set up a notification automation which would send someone a notification when the status of a deal changes. Attached Screenshots. However, I am unable to get any notification. Do i need to apply a different automation or is my current one missing something? Thanks!
-
Count Issues Resolved Today
I am trying to create a formula that will count the number of issues resolved with today's day. I've tried using =COUNTIFS({Resolved Date Range}, IFERROR(DAY(@cell), 0) = DAY(TODAY()), {Resolved Date Range}, IFERROR(YEAR(@cell), 0) = YEAR(TODAY())) It counts okay, but it does not give me the correct value. Once I get that…
-
Help calculating the state (Status) column so I don't have to manually update it
Here is the formula I am using: =IF([% Complete]@row = 0, "Not Started", IF([% Complete]@row = 100, "Complete", "In Progress")) The "Not Started" and "In Progress" work well, but not the 100% complete.
-
sumifs with multiple ranges
Hi there, I'm stuck in finding the right formula for this, hope someone in here can help. I have a master sheet(Demo Commission) with PO# and different agents getting different % of commsion. In the bottom sheet (Demo- John), it's John's commission in detail. It has different two columns, one for commission % and…
-
Is there a formula for what I have described below?
I want to add or subtract a row in a separate column when another column’s row has data. Basically I have a master column that houses certain numbers one being 46. I have other columns that are name Date item added and Data item removed (Date). My goal is that when someone adds a date in a row in the add column, the master…
-
How to auto copy (insert) formulas onto my Smartsheet
Hi, I have a sheet that has numerous formulas and functions in various respective columns. I am looking to see how best to have the formula automatically copy down as rows are added to the sheet. We in be bulk importing various records that will populate various columns, in addition to use a Form to create rows as well.…
-
2-dimensional filter
I have hit a wall on ideas so thought I would reach out to the Smartsheet Community to see if anyone had any ideas, workarounds, or suggestions of how to accomplish a "2-dimensional" filter since there doesn't appear to be the capability (at least I'm not finding a way) to combine the "AND" and "OR" criteria to a filter.…
