-
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") +…
-
How to create a stacked bar chart with Widgets
Hello, I'm trying to create a stacked bar chart with the below data. Is there a way to show the below % completed without expanding all and incorporating the lines collapsed? I want to see just what is highlighted below on a stacked bar chart. Any help is appreciated!
-
Join Function Sometimes Adds Two Columns rather than Joining
When I use the formula =JOIN([PO number]@row + [Line Number]@row) sometimes the two columns are added instead of joining For example, I'm trying to join a PO number and line number to create a unique identifier. The Join function adds the two numbers. I have also attached an example.
-
formula for point in time averages
Hi, I have a sheet that has averages for various things such as how long it takes from date a job control closes to when interviews are held. I have to report in 2 week increments - by the individual area -- for example district 1 held interview 01/01/24 thru 01/15/24, then again on 01/16/24 thru 01/31/24 -- I need to show…
-
Outbound Cell Limit - Who's Calling Me? (Outbound Cell References)
@Andrée Starå @Paul Newcome @Genevieve P. I understand from a different post that there is a 25 million limit on outbound cell references. Is there any method to find out who's calling the master lookup (source) sheet? A list of all sheets that reference the Lookup sheet? What about pivots and DataMesh - any ability to…
-
Using Smartsheet to book rooms/properties and export data for billing purposes
Hello, this is my first post. I am looking for a solution that would allow my company to book rooms in properties that we own. The input for the booking form or sheet would be Employee Name, Company, Job #, Check-in Date , and expected Check-out date. This would allow us to manage what employees, companies, and job #'s are…
-
SUMIFS with ranges on multiple sheets
Hi there! I have a metrics sheet that I use to calculate the number or weeks each account manager booked on a given week of the year. The formula I have currently that works references one sheet only. However, that source sheet has an automation set up so that once the booking is completed, the row moves to an archived…
-
Need help with Nested If Statement
I need some help with a nested formula. I've spent hours on this and cannot seem to get it to work. I'm basically looking for the following function: If date column 1 and date column 2 are not blank, then, If these dates (date column 1 and date column 2) are the same, enter 0, if not, return the number of days between the…
-
Using Automations to Add End of Month Date to New Row
I'm relatively new to Smartsheet. I have a sheet that I would like to use a workflow to automatically enter the date at the end of the month to the next row. So, on January 31, I would like the workflow to run and enter 1/31/24 in a date column on the next blank row. I've tried using the Record a Date action in a workflow,…