-
Average duration for a specific type and year
I'm trying to get a formula to work in the Sheet Summary for a sheet I have that collects data on updates I would like this formula to tell me the Average duration of a specific type of update for a specific year. The columns my formula is looking at: Duration (days) - Text/number column Live Date - date column Update Type…
-
Sheet Calculations are not copying
I have a complex sheet where users are entering data from a form and the sheet should be making a series of calculations. Each entry should be the next row (e.g. form enters to the next in in series) and then as the work is completed the process is updated on the sheet. It seems though each row is blank, the calculated…
-
Is it posibble to have If(Isblank) return a yes, no, NA?
ColA will have a date or NA. ColB will have a date. I would like Col C to be blank if ColA is blank, =Yes if ColB is <=ColA, =No if ColB is >ColA, and NA if ColA is NA Is this possible?? I get this far, but not sure how to autmate the NA =IF(ISBLANK([ColA]@row), "", IF([ColA]@row <= [ColB]@row, "yes", "no"))
-
When Date field is blank #INVALID DATA TYPE appears
I am using the following column formula to project 10 working days from the time a form is sent. How to I change the formula to remove the #Invalid Data Type when the Date field in Date Payment Request Form Sent is blank?
-
How to return multiple values from a sheet and paste them on multiple cells, based on criteria?
Hi, I have one sheet where there is a column with order numbers. There is also a shipping date column, which has a shipping date for each order number. The sheet itself is called Shipping. On another sheet, I want to return all order numbers of the next 3 weeks. I tried using the Index(Collect()) formula at first, but…
-
Formula to automate the symbols on a sheet.
The Task Progress column is linked to the % Complete column. when someone inputs a value of 100% in the % complete column, the task progress changes to a Green dot, and the same goes for when the % complete is 0% - Red dot, 1-99% - Yellow dot. I would like to add a gray dot in the mixture so I need a new formula to reflect…
-
How to edit certain font in Widgets
Hello, Are there ways to edit some (but not all) font on a stacked bar chart? I found where I can edit all font to the same but need to bold a few titles. Thanks,
-
Add/Delete certain columns of rows based on criteria
Hi, I'm fairly new to smartsheets. I'm trying to have automation copy/delete certain columns from from sheet 1 to sheet 2. I've created an example below to give context what I want to do. The order status column is a dropdown so whenever rush is displayed I want the Employee, Order Number, Cost, and Order Status columns…
-
How to calculate the difference between two values and display the result with a + or - sign
Hi community! How can I calculate the difference between two values and display the result with a positive or negative sign depending on whether the difference is upward or downward? For example, if I have two values: 5 and -2. I need the following result: -7. And if I have: -5 and -2. I need the following result: 3. Thank…
-
Getting Same Resutl with Slightly Different COUNTIF
Hi Guru's, I run the below formula and it gives me the correct number however; I modify the formula to look at another range however; I get the same result as the first formula minus the 2nd range. 1st formula =COUNTIFS([Operational Priority]:[Operational Priority], ="🔶", Status:Status, "In Progress") +…