-
Countifs off by one
I am trying to get a count for a date range, but am getting a number that is one less compared to the filter. Current Tuesday Formula: =IFERROR(TODAY() + (3 - WEEKDAY(TODAY())) - IF(OR(WEEKDAY(TODAY()) = 1, WEEKDAY(TODAY()) = 2), 7, 0), "") Previous Tuesday Formula: =IFERROR(TODAY() - 7 + (3 - WEEKDAY(TODAY() - 7)) -…
-
Force upper case on a column
Hello Everyone, I got a question. Is there any way to force upper case on a text column? I have a column where users enter information using iPads and it will be very helpful if the cells will automatically force to have upper case font in it. Thanks
-
UPPER formulas
Is there a way to set a formula so all text in the column or sheet is upper case even if someone enters it on a form in lower or title case?
-
Elapsed time from a system column to the current datetime
Hi guys, I need some help to calculate the hours and minutes have elapsed from a system column (which is the ticket creation date) to the present date, not sure if it is possible to use TODAY() formula. Here are some screenshots of what I have so far, but seems like the minutes calculation is not working. The ultimate goal…
-
Countifs for if either column is checked
I have two checkbox columns and need to get a count of how many rows have either or both of the check boxes checked. I am struggling on how the formula to accomplish this is the sheet summary. Below is my current equation for getting the count of one of the columns, I am able to do this for both to get a count for each…
-
Summary field with formula by API
Hello everyone, I have a function that I run via API that helps me replicate improvements across all the spreadsheets for projects I work on. I tried to insert a new formula field into my spreadsheet using this function and it worked perfectly. However, the field results in a formula error and I need to access all the…
-
IF/AND/OR formula help
I currently have a formula that works that checks the red flag if either of these two situations are present; 1. the end date is prior to the start date; or 2. the end date is more than 4 years from the start date. This is the formula: =IF([Target End Date]@row < [Target Start Date]@row, 1, IF(AND(OR(NETDAYS([Target Start…
-
Modify scale on an axis of a graph
Good Day t´s possisble modify scale in an axis of a graph exist? for example, I have a graph, in the vertical axis the scale it´s 0.5 to 0.5, but i want that scale will be 1 to 1, it´s possible? regards
-
Age Formula Keeps Rounding Up
This is my formula: =IFERROR(YEAR(TODAY()) - YEAR([Date of Birth]@row - IF(TODAY() < DATE(YEAR(TODAY()), MONTH([Date of Birth]@row)), 1, 0)), "") It keeps rounding to the next age. For example, 04/09/1978 is showing as 47 but it should say 46. When I add decimals it says 47.00. I also need the age to only populate when…
-
My IF statement isn't importing from excel and can't figure out why
I have what I think is a fairly simple nested if statement that isn't importing into Smartsheet, it just shows blank and I can't figure out the issue. The excel formula is: =IF(ISNUMBER(C2), IF(AND(ISBLANK(X2), ISBLANK(Y2)), TODAY() - C2 + 1, IF(AND(ISNUMBER(X2), ISBLANK(Y2)), X2 - C2 + 1, IF(AND(ISNUMBER(X2),…