-
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!
-
Filtering Columns in Reports
I have a master sheet which has data pertaining to different departments. From this master sheet, I'd like to show only the information relevant to a department to that department, and none of the other data. 1) How do I restrict the datas in the columns that have to be shown 2) If out of 4 child rows, 3 pertain to one…
-
Reporting Hierarchy
I have a sheet with several parent, child and grandchild rows. I'm creating a Report from this sheet but I am unable to filter and see child or grandchild wise. I have created a WBS System (1, 1.1, 1.1.1 -> Parent,Child,Grandchild) as well but unable to group/filter using this. Is there any work around for this?
-
Formula Needed- Return date from week number
Hi All, I am in need of a formula that will return the date from a specific week number. We work off a unique week number calendar. Because of this, I haven't been successful using the week number formula. I hope to use 5.1.22 as week zero/launch date and have this date specified in my sheet summary. I also have a…
-
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.
-
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…
-
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."
-
Need help with Distinct Count with multiple filters please!
Hi All! I'm trying to figure out how to build a formula to track how many clients still have outstanding issues on a different sheet. I have a basic count of outstanding tasks. =COUNTIFS({Reference Sheet}, "Outstanding Task") When I tried to add Distinct to this, it understandably changed my total to 1.…
-
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…
-
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.…