-
Formulas with multiple inputs in smartsheets. Help needed!!
This has been a challenge for me to figure out using the smartsheet platform. I am developing what is essentially a big calculator. The formula that I am trying to implement is: [($26,000 * DTH) + (Risk R * Repair Cost) + (Risk A * repair cost)] * frequency). In this database, each row represents an additional input. The…
-
Sum of column values that come from function formula
I have created a formulation of a drop down with prices associated with each selection that population on a different column: =IF([Repairs Needed]@row = "Tuck Point", "125", IF([Repairs Needed]@row = "Tuck Point Panel", "450", IF([Repairs Needed]@row = "Tuck Point Column", "150", IF([Repairs Needed]@row = "Tuck Point Major…
-
AVE or AVERAGEIF when refrencing another sheet
I have my master sheet set up with a duration column. I've been trying to build a formula on my metrics sheet that will allow me to average the duration column based on who is assigned that purchase order. I've tried two formulas, one using AVE and the other using AVERAGEIF and both return the #UNPARSABLE error. The first…
-
Slot scheduling conflict within a date range
Hello Smartsheet Masters, I am making a scheduler sheet for equipment slots. The sheet contains these columns: Conflict (Checkbox), Row (Dropdown list), Slot (Dropdown list, multi-select enabled), Start Date, End Date. I would like the Conflict cell to be automatically flagged if any one or more slots have already been…
-
Using nested MATCH/INDEX across multiple columns
Hi, I'm using two sheets to track the distribution of transportation gift cards, one will be a master list of the cards and the other is a webform tracker that distribution partners use to log who receives cards. I want the master list to check off each card given out after it is logged into the tracker, however each…
-
COUNTIF formula returning 10 extra blank lines
I wrote a formula to count the total number of unassigned purchase orders in my sheet, which looked to be working at first glance, but upon comparing it to the actual data in the sheet, realized that it is counting 10 ghost orders. This is my formula: =COUNTIF({Assigned}, ISBLANK(@cell)) The Assigned column is a contact…
-
Can a duration column with dependencies not pull data from a created date column?
I have a sheet with a created date that is generated by the system upon submission of the project. I wanted to create a column that tracks the duration of the project from submission to delivery with dependencies, but when I click the drop-down under project settings it doesn't have that created date listed. Is there a way…
-
Ability to change default background color and background color in sheets
I think the ability to change the background color in smartsheet would be very beneficial in helping avoid eye strain. Most of us are looking at white screens all day and our eyes get very tired and strained. Even with special blue blocker glasses I still notice the eye fatigue. Please consider adding this feature in a…
-
Help on formula: format numbers and shorten to K (thousand), M (million), B (billion)
Hi all, So I was able to get help around here on how I could turn amounts in thousands and millions to just K and M instead of displaying lots of zeros. Now I would like to add a formula in to just round it up with just 2 decimal places and to shorten billions too. Can someone help please? Here's my current formula:…
-
Find middle number using LEFT and RIGHT Formulas
I have a column with dates that look like this 2022-10-18. I am trying to create a formula using LEFT and RIGHT to only give me the month (in this example = 10) Please help, thanks!
