-
COUNTIFS + AND Formula does not Equal the Filter Count
Good afternoon. I am having issues with the below formula equaling the filter within the sheet that we are pulling form. Please see the below and point me in the right direction to help fix this. Formula: Filter: BC/PO/BL | is one of | PO, BL, SSA, Lease, License, Other Non-Board Items Status | has none of | Awaiting CRF,…
-
Sequential Numbering Autopopulate Row
Hi all! I am trying to create a formula where every time I add a row, it aligns with the next number in the series. If it reaches a level 1 row however, the series goes to the next whole number. I wrote out manually what the numbers should be but I would like a formula to apply this automatically when i add a new row. Im…
-
Populate Column With Unique Values From Another Sheet
Hi all! I have a sheet, where tasks are entered and assigned to employees. Every task belongs to a certain company, which is specified row by row (every row is another task), this describes the first sheet we'll call "Requests". I want to create another sheet to summarize the data of every task for every company, this…
-
Concatenating values from two columns with 20 spaces between them
Hi guys, I have a task to concatenate two strings from two different columns with formula. The values are for example SEA129 and 01. What I want to achieve is a string which will look like this "SEA129 (20 blank spaces) 01" Has anybody encountered similar issue?
-
How to calculate time in smartsheet
Hi, How to calculate difference in time in smartsheet for example Start Time = 12:23:20 and End Time = 20:23:20 I want the difference between this two time in third column = 8:00:00
-
Calculating Age Monthly
I have a smartsheet with many events that often span several months. I want to calculate the average age of relevant events for each month. For example, for the month of March, I want it to calculate the average age of events that are still open in March in addition to the age of all events that were closed within the…
-
Average that meets Criteria 1 or Criteria 2
I have a smartsheet with many events that often span several months. I want to calculate the average age of relevant events for each month. For example, for the month of March, I want it to calculate the average age of events that are still open in March in addition to the age of all events that were closed within the…
-
How to Identify Duplicate Job Numbers on Multiple Sheets?
I manage 30 production projects across three Smartsheet sheets: one main sheet (Project Management) and two spin-off sheets (for Ordering and Install Certification tracking after a project ships). All sheets use a unique 4-digit job number for each project. What’s a formula or function I can use to quickly identify if any…
-
Formula to Identify Number of Forms Submitted by Individual Offices
Hello, I am working on building a dashboard to display global and individual data regarding different requests (out-of-state travel requests, official functions, etc.) across seven offices. I would like to eventually calculate the monetary value of each of these requests, labeled as 'Amount' on the reference sheet. I am…
-
Updating Previous and Latest checkboxes based on a value in another column.
Hi & Happy Friday, I'm putting together a status reporting sheet and I need to be able to update the previous and latest rows, based on a separate column, in this case the Submission Status column. Formula in the Previous column is: =IF(([HC-Row ID]@row + 1) = MAX([HC-Row ID]:[HC-Row ID]), 1) Formula in the Latest column…
