-
Incorrect Argument Set
Please help: why am I getting this "Incorrect Argument Set" =SUMIFS([Targeted Area]:[Targeted Area], "Atopic Dermatitis", [Approved 2022 $$]:[Approved 2022 $$], 1) This formula uses 2 columns [Targeted Area] and [Approved 2022 $$] (which has the $$ approved amount) and says... look at the "Targeted Area" column, if it is…
-
Display Hours & Minutes (Time) as Minutes
Good afternoon all, I have a column that displays time taken to do a task in this format: H:MM I would like to have a column at the end of my sheet that displays this information in minute format. Please can you help with the formatting. Thank you
-
Using IF to return a value from another cell
Hi All, Currently we have the below system in place to return the value of a specific cell out of a specific column. So for example, If the country is Germany it pulls the information out of the Germany Column. This works great! But now comes my problem. We have added a Germany Refurbishment Column. So now it should work…
-
Where in this formula would I add in within 1000km
I use a smartsheet to track my fleet. When something meets this criteria it ticks the box and then an automation is activated. I was wondering how I would change this so somewhere in the formula the km's were within 1000 or over the RUC amount. This way before it is overdue, it sends the email. Here is my current formula…
-
How to convert to a date
HI all, I'm trying to get a text string from one column (lot code) converted into a date in another column. The first column contains numbers such as: 202405 Ideally the date column would read the first four digits as a year, and the last two as the month (all of the days can be the first). So far I have: =DATE(LEFT([LOT…
-
How to calculate time
Hi. What's the formula to calculating time? For example, in one cell, I have my starting point of 6:00am. And in another cell, I have a finish time of 11:00am. What's the formula to calculate time between these two points? Thanks in advance.
-
Automation to "Change Cell Value" to embed a formula into the cell
Trying to set an automation to "Change Cell Value" 2 columns involved: "BARCODE" and "PACKAGE UID/LOT #" If "PACKAGE UID/LOT #" is not blank, then I don't want to override the data in the cell, however, in the absence of data in that cell ("PACKAGE UID/LOT #" is blank), then duplicate the data from "BARCODE" into "PACKAGE…
-
Formula to Hyperlink contents of a column into another
Hello, I have two columns, one with a URL, and one with text. Is there a formula, or automation / process that can hyperlink the URL and text into a new column? I have the need to hyperlink a few hundred rows of data and want to avoid the manual hyperlink method (copy URL, cmd K , paste link etc...)
-
How to calculate variance between dates with referenced values?
Hi all, I tried using the NETWORKDAYS formula and it appears it only works when you have date columns where you enter the date manually. I have a project rollup sheet which I am trying to calculate the variance of NETWORKDAYS (which considers the non-working days) of 2 columns which references dates from another sheet.…
-
Can anyone help me with my formula for ticking a box?
Hi Guys! So here is part of my database with the information I collect. My issues is my formula only picks up dates and I was wondering if anyone can add in kms too? So under Service required I have this formula : =IF(OR([Odometer Reading]@row > [Service Due KM's]@row, [Service Due Date]@row <= TODAY(21)), 1, 0) But lately…