-
Stacked Chart
Hi All! I am trying to move a document from excel into SmartSheet and I was wondering if anyone knew if I could recreate this data into a dashboard chart? It is not currently set up as a chart in excel, it is a tedious exercise of lengthening and creating new shapes to designate the progress. I have tried a couple…
-
Task bar colors in report calendar view
The taskbars in my report calendar view aren't reflecting the taskbar colors in the underlying sheets, making it hard to tell which sheet the task is from. Anyone got any insight? Thx.
-
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…