-
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),…
-
Issues with Convert to Column Formula
Hi, I have a column that I'm trying to convert to column formula but won't because "The column formula syntax isn't quite right" and gives me Smartsheet's help article for more information. The column's type that I'm trying convert is "Symbols" and is the Progress Bar. The Formula of the attached example is: =IF([RPM %]851…
-
2 tracker sheets, merged into one resource sheet?
Hello, I have two sheets, one is a fabrication tracker that tracks different jobs in our machine shop, and we have a design tracker that tracks current designs being worked on. I would like to combine both trackers into one resource tracking sheet that shows [Name] [Job #/ Design #"] [Role] [% Occupied]. Image below is…