-
Direction symbol in formula
I would like to use the direction symbol (up,down,sideways) in a formula if =IF([ISS-Backlog]1 < [ISS-Backlog]2,“Down”) but it is not working. Any help would be greatly appreciated
-
Count Ifs Dates in the future with multiple conditions
I am trying to create a formula will return a count of dates 21 days from the current date, but also sorted by an Assigned persons name and multiple statuses of the request. Here is a formula that I have so far: =COUNTIFS([Assigned To]:[Assigned To], "Name", [Status]:[Status], "Scheduled", [Start Date]:[Start Date],…
-
Formulas COUNTIF between to numbers
Hello, I am new to the Community. I am having such trouble with designing a formula that will use two past due days for which to count. Here is what I have for the 30 to 59 days count of past dues. =COUNTIF({Audit CAP Summary Range 1}, ">=30") + COUNTIF({Audit CAP Summary Range 1}, "<= 59") It returns a number but the…
-
Average Value Errors
Hello, Was hoping someone could see what i am doing wrong here; i am attempting to take the value of two cells and average them. Both are percentages. i use the formula =AVG([average calc]33, [average calc]34) and i get the "DIVIDE BY ZERO" error. From what i read this may be due to the particular column is a dropdown list…
-
Need Super Simple Formula (7 days before "Due Date")
I want a new column to reflect the date 7 days before an existing due date column. What's the formula?
-
Formula -- If next 4 Columns say Yes/No say something
Hello, I have a sheet with six columns. They are: Name | Current Step | Step 1 | Step 2 | Step 3 | Step 4 Step 1 - 4 have Yes/No written in them for completion status. Can I have a formula in Current Step to count how many "Yes" there are and print the Step? Can someone direct me to where I can find out how to code this? I…
-
Countif using Dates and another Range
I'm trying to use CountIf using the my auto filled date column and another column. The 2 parts of the formula I have come up with work independent of each other, but when I try to put them together I recieve the #INCORRECT ARGUMENT reply. Not sure what is wrong. Below is a copy of my Formula. =COUNTIF([Request Create…
-
Cross sheet sum if
I'm creating a sheet to record the use of agency/contracting staff across a site (once the proof of concept is done it'll be expanded to cover multiple sites), where entries will be added to the sheet below via form. The "within budget" column on the 1st sheet should be picking up any entry from the Month Total Spend (MTD)…
-
Dashboard icons appear oversized
Just logged into smartsheet and all dashboard icons appear oversized completely disrupting the functionality of shortcut widgets. This is the first time I've see this. Same issue on two computer and three different web browsers (IE, firefox, chrome). Anyone seen something like this before? Thanks, Mike
-
Monthly, 6 Monthly, 12 Monthly reporting
I'm currently working on a KPI structure for my organisation. An entry will be made each month via a Smartsheet form, and they'd like to know the latest entry, as well as the last 6 month and last 12 month totals. I'm struggling with how to calculate these. I assume that I'd use the max function along with a created date…
