-
Calculating Fuel Consumption
Hi there, I manage a transport fleet and want to use Smartsheet to track the vehicles' fuel consumption. It is calculated by subtracting the kilometres from the previous fill-up from the current fill and dividing this variance by the litres of the current fill-up. See attached spreadsheet. The problem is that fuel fill-up…
-
Pull Text from String using Delimiter
I would like to parse the text from a string in another cell. However, the string might not always be the same length so I cannot use LEFT or RIGHT. Here are two examples of what the string might look like: 1,5,7,33,15 13,22,8,1,16 Both examples above have 5 numbers separated by commas. What would the formula be to always…
-
Statement to read a text in one cell, then add a numeral (based on the text) to the date in another
Hi all, help please :) I have 3 columns - Approval Due Date Requested Date Priority Step 1 - Approval Due Date to look at the Priority Priority will be High, Moderate or Low / High = 7 days /Moderate = 14 days / Low = 21 days THEN Look at the Requested Date column and add the number of days relevant to the priority rating…
-
Cell 1 to equal Cell 2, if 2 blank, then 3, if 3 blank, then 4
Hi all, I have 4 cells, what I need is: Cell 1 to equal Cell 2 If Cell 2 is blank, then read Cell 3, If Cell 3 is blank, then read Cell 4. I have searched quite a few discussions to try and replicate but cannot seem to get it to work. Cell 1 - Approval Status Cell 2 - Approver 1 Cell 3 - Approver 2 Cell 4 - Approver 3 Any…
-
Using IF, AND functions together.
Hello, I am trying to create a formula whereby, if the date in the "Due Date" column is less than today and if the "Approval Completed" column box is unchecked, return 1 or 0. I need to calculate how many tasks are past the due date. Unfortunately I am getting errors in my formula, can anyone help. Thanks.
-
I want to count dates in the colum "Solldatum" that are smaller than today.
I tried it with countif and it worked in Excel in German with the following formula: =ZÄHLENWENN(A2:A13;"<"&HEUTE()) as Example. What do I have to do in smarthsheet to get back the number of valid dates (in this example above the value "2")
-
Based on location, convert survey responses to a numerical value in separate sheet
Hi, I created a form to collect survey results, the responses are returned to Smartsheet #1 (image below). The survey has 18 questions with these dropdown (single select) responses: Good Satisfactory Does Not Meet Standards Not applicable In Smartsheet #2, I want to search for responses for "Phoenix" and then convert the…
-
Which formula should I use if I want to add up all values from a column?
To give a little bit of context, I am creating a report where I can count whether a cell has been filled with information. The column I am using is a drop down list with 5 values. Let's say these values are apples, bananas, oranges, pears, etc. I am not looking for the total of each specific value, I want all of the values…
-
Multi-Select Column Formula to Add Values
Is there a way to add values to a multi-select column using a formula? I have several sheets that i want to switch from checkbox columns to a single multi-select column "Subscribed Calendars". It is VERY manual right now doing it by hand and will take a ton of time. I've tried using the "IF" formula, but it only adds the…
-
Average if contains a specific word
Hi! I'm trying to type a formula which could tell me the percentaje of the cells that are in color green, those cells are painted in green when I type the word "Listo", so I found that formula (showed in the image) in the community questions, but when I type that formula it drops me a 0. Could somebody tell me how can I…