-
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,…
-
Countifs not working for project by month
Hello all, I want to count 3 different project types, by the number our team does each month. Two of the 3 project types are coming back with data. Why am I getting an error on the other? Here is a snippet: I keep getting the invalid data type error on it.
-
Blank Date in Formula
Hi, Can someone help me with accounting for a blank date? The formula works if I enter a date in the Current Coterm field otherwise it shows Invalid Data Type. =IF([Initial or Renewal term?]@row = "Initial", IF((DAY([Current Coterm Date]@row, [Actual Billing Date]@row) / 365 * 12) > [Initial Term NLT]@row, DAY([Current…
-
Formula to pull metrics for previous month
I currently have a formula that pulls metrics into a sheet for a dashboard widget, it currently pulls the data if the month in the month column is the current month. I need it to pull the metrics for the previous month but I can't get it to work. What am I missing? I tried adding a -1 behind the MONTH(TODAY())-1 but that…