-
Is there a way to populate a new sheet with data from a separate sheet, when it meets a certain crit
Is there a way to populate a new sheet with data from a separate sheet, when it meets a certain criteria? I have data being added to a main tracker that is used by many people. Therefore, editing access is locked down. I want to move specific lines to a new sheet, so I can share that sheet and have it be edited by external…
-
Tying to write a IF formula
IF "fuel Type " = Diesel , Multiple "Gallons Dispensed" x "Price Per Gallon", IF "fuel Type " = Gas , Multiple "Gallons Dispensed" x "Price Per Gallon", I would also want to change the Price per gallon at a certain date, When I get a fresh delivery of fuel, without changing all info in the sheet, only moving forward from…
-
How to Add and Equate for an Empty Field?
We have an intake sheet that we just updated to include a new field that will only have data input on a rare occasion. I need to figure out how to update my formula to take into account that input as we are measuring as a pass/fail system but I need it not to affect when it's empty. Here's the current formula:…
-
Does Smartsheet integrate well with any barcode generators?
I'm heading the inventory control department at our lab and we'll need to be able to track parent and child samples throughout the lab via scanning them at which ever work station they happen to be at. Any recommendations for a good barcode generator that works well within Smartsheets would be appreciated!
-
Formula within cell
Hi there, Thank you for helping me out! I'm working with a SS that contains some specific information. Due to internal regulations, each new job requested must contain a URN, which I would like to be automatically generated based on information from the existing sheet. The format I would like is as follows: [Stand type]…
-
What formula can I use to update the data based on a change in 1 cell with the date?
I have searched far and wide for a formula that may help me achieve what I need, to no avail. I have a data table that is updated weekly to showcase upcoming launches based on their scheduled launch date. I currently manage this in Excel but the data is currently on a Smartsheet grid. Ideally, I'd like to build out a…
-
number of weeks between two dates
Please can you help find a formula to work out the number of weeks between two dates I want to know if there is a 5 week gap or not between date now request and proposed works columns the 5 week mark always starts on a monday e.g. if date requset was 30th July 25 then the five week mark would start on 4th august 25 - if…
-
RAID Formula for Dashboard
Does anyone have a RAID log formula they can share to calculate the overall and individual project health of a project based on the amount and priority level of Risks and Issues? Currently, I have formulas that evaluate the status of issues and risks in our RAID log which return color codes (Red, Yellow, Green) in a…
-
Formula Guidance
I'm working on a project that involves matching organization names across two sheets, but I'm running into some complexity and could use guidance on how to approach it. The source sheet contains all organizations that have received donations since 2020, including donation amounts, dates, and progress status. The secondary…
-
Totalling Number of Tasks from Dates
Hello Everyone and @Paul Newcome I have a sheet with "Date Record created" and the dates are in the usual format 29/07/25 etc. I want to show a graph on a dashboard, how many tasks are from 2024 and how many are from 2025. I have created a new sheet to create the formula but I am getting "Incorrect Argument", please see…