-
Why is my COUNTIFS formula counting more items than necessary?
Hi all! I'm currently using the following formula (with references) to count the amount of items that fit a certain criteria (91-180 days, 181-270 days, and >270 days): =COUNTIFS({Age Grouping}, "desired amount of days") The formula works perfectly for the first two criteria, however, when it counts ">270 days", it returns…
-
Dashboard Reports & Row Attachments
Hi! I was wondering if there might be a way to display the "attachments" or "comments" column of a report via the report widget when working on a dashboard? Essentially, I would love to be able to see if/when a row has either a comment or attachment linked to it via the dashboard. It would be even more amazing if that…
-
Formula comparing dates
I am very new to Smartsheet and the making of formula's overall so sorry for this question. I want to create a column where it will be highlighted when the date from column x is 4days or less apart from the date from column y. Does anybody know which formula to use? I started with this: =IF([column x]row number < Many…
-
Multiple forms to a record
Hi, Wanted to check if there is a mechanism wherein smartsheet can store the information collected via different forms at different points in time in a single row ? Providing an example below for more clarity - Lets say we break the client engagement (an enquiry -- lead generation -- service agreement) flow into multiple…
-
Auto fill information in sheet when a check box is checked in a different sheet?
Hi! I am trying to figure out how to auto fill information into my sheet, when I check a box in a different sheet. Essentially, all I want to do is autofill the check box on sheet 2 once it is checked on sheet 1. Is this possible?
-
referencing using @row
I've tried multiple searches and haven't found the right keyword/tricky phrase to answer my question. I am using a form for submissions and trying to calculate how long a trend has been occurring. Right now my working formula is this: =IF(DidIncidentOccur@row = "Yes", 0, IF(YEARDAY(Date1) > YEARDAY(Date2), DaysSince2 +…
-
Formula for totalling specific options
hello! I have a sheet for a menu of options. We are building kits of different swag items and the sheet has 5 different options with different price breaks. I'd like a sales rep to be able to go in and select different options then see a kit price. I was thinking I could add a check box column then pull a report on that…
-
Use date and status to define RYG balls
Hey all, Trying to make a simple task management sheet, using today's date and the task status to define a Red, Yellow, Green or Grey ball. If end date is today or later, AND status is not complete or cancelled, green If end date is today -1, AND status is not complete or cancelled, yellow If end date is today -2 or…
-
Auto-populate a value in the cell of a column, based on previous values
Hi, Appreciate your help! I have a sheet, where Auto-number is taken up for the first column. I have a Priority Column, which I want to auto-populate based on if the number already exists. Item # | Item Requested | Priority 21 | Test 1 | 1 23 | Test 2 | 2 24 | Test | 3 25 | Test | ---here the number should auto-populate as…
-
Highest value on the last six values of data
I'm looking to find a formula that will capture the last six months of data and then return the highest value within those six values. On excel, I've used, for example, MAX(OFFSET(B3,COUNTA(B3:B113)-6,0,6,1)) but I see "offset" is not compatible with smartsheet. I don't believe Index and Match would work with what I'm…
