-
Nesting a SUMIF function
Hi community! I have several columns of numbers that I want to add up in different ways. Next to these are two checkbox columns. I want to add up each column individually if both checkboxes are checked. So in the example I have a series of data columns Q1 to Q4, each with a row label and next to each row label are 3…
-
Estimate End Date, Actual End Date, Adjusted End Date flagging
For my projects I track Estimated/Actual Start and Estimate/Adjusted/Actual End dates. I need to have a status flag indicate yellow if the Adjusted date is slipping past the estimated end date, and then when the end date is adjusted and justified, to update the status flag back to green. Is anyone tracking like I am? Do…
-
Type selected - allows certain columns to be updated
The checklist type smart sheet will be setup with columns called Vendor, Type, Doc 1, Doc 2, Doc3. What I want to do, is depending on the type selected for a particular vendor, the doc columns will grey out for those doc types needed for that specific doc type. For Example: Vendor 1 Type Critical All doc type columns would…
-
Item Tracking
I am building an item tracking report with a helper column. There are 14 different items, and I want the helper column to post 1 (or anything it honestly doesn't matter what it posts) if it is the most recent action for an item for the purpose of building a report. I've got an autocreated time column and autocreated index…
-
Formulas
I want to create a formula in a cell that subtracts a certain number of days from another cell that is linked to another persons Smartsheet. How would I do that? My efforts have failed.
-
Lookup with #NO MATCH error
I've used the Lookup formula to find hours per work order number. Until today, the formula reported "0" in the event the lookup value was not found. As of either Jan. 17 or 18 (today), it now reports "#NO MATCH" when the lookup value is not found. Did something change recently with the way this formula works?
-
automatic notifications when dates are passed
We created a new sheet for tracking our work and have a cell with a due date for design submittals. There is an empty cell next to the due date that we want the user to add either a check box or date to show the submittal was actually done. The question is, if the date or checkbox isn't filled out after the due date has…
-
Tire Maintenance - Form / Spreadsheet Assistance
Hello All, Today is my first day (YAY!). I'm digging Smartsheet thus far, although, I'm looking for suggestions. I've been tasked with creating a Tire Maintenance Program. So far I've put the basic asset information (Year, Make, Model, VIN, Tire Size(s). Screen shot will help make sense of this. The key part is trying to…
-
Formula Help - 2 columns and % Calculation
I am trying to give a percentage based on how 2 columns read. Column PassFailA and Column PassFailB. If both show Pass 100%, If A is Pass B is Fail or Vise Versa 50% and if both Fail 25%
-
Formula Help - 2 columns and % Calculation
I am trying to give a percentage based on how 2 columns read. Column PassFailA and Column PassFailB. If both show Pass 100%, If A is Pass B is Fail or Vise Versa 50% and if both Fail 25% I think this will work, but will take any advice if there is a different way: =IF(AND([pass1]31 = "pass", [pass2]31 = "pass"), 1,…