-
Reaching for Specific Information Return
I am trying to use a set of sheets for material tracking from various suppliers without actually having to have my employees use several sheets to do it. I am wondering if there is a way/formula to look through a specific column for a supplier name, and in whichever row it finds said supplier it then outputs that entire…
-
If Checkbox is not needed, show blank
Hello Smartsheet Gurus, I have a spreadsheet that has a few columns as checkboxes, but when the checkbox is not needed, I want the cell to show nothing. Is there a way to do that? Thanks, Arryn
-
Create a Formula that compares Dates in 2 Columns and Counts a Total
Hi all, I am trying to write a COUNTIFS formula that compares multiple criteria. I need to Count all items in a column that have a status of "Completed" (column A), IF the items also have an Actual End Date within 2019 (column B) , and the Actual End Date is less than or equal to the Scheduled End Date (column C). I cannot…
-
Import Excel Workbook
Good morning, Is there a way to import a whole excel workbook and not just 1 tab?
-
Zapier or Automate.io Basecamp Integration
I create all plans in Smartsheet and need the tasks/date/owners to show up in Basecamp to do's or schedule section. I've tried Automate.io and Zapier with no luck. Can anyone provide insights? Thanks!
-
Sheets, or partial sheets displayed in 'Sights' dashboard
I know several of us use cell linking to creat roll-up reports of our data, but these reports cannot be displayed in a 'Sight', becase they live on a sheet, not on a report. Is there a way, or can i recommend a functionality, that allows for a sheet, or part of a sheet to be put into a sight for quick visibility?…
-
IF/AND Formula
I am trying to create a formula to track invoices that are completed under 30 days. If the number in the "Invoice Duration" is less than 30 I'd like the next column "<30 Days" to populate with "Yes" If the number in "Invoice Duration" is more than 30 I'd like it to populate "No" Thank you for all the help!
-
Formula -weighted for specific criteria
I have a complicated request. I want to create a formula that will provide a % when a row is designated as a "critical path" item. See screenshot. As a box is checked in the column for each cabin name, I want to get the % to update for those critical checked boxes. Is there a way to do this? I already have a formula that…
-
SUM of consecutive cells until blank cell is reached in the column
Hi, i am trying to SUM any given number of consecutive cells in column A and need it to stop once a black cell is reached. For instance The SUM will be column A, row 2 to 6 (7 is blank) and I am wanting the SUM to display in column B row 1. This will repeat throughout the sheet, but the SUM result will always be column B…
-
Parent Row Roll up using a specific text value
Community: I am piggy-backing off Nathan Skyers' request from November 24, 2016 1:13 pm, regarding Parent Row Roll up, as I need a very similar formula. Any help will be appreciated. Thank you, Sandy Is it possible to have a text value show in a parent row whether all statuses match my criteria OR if even one status…