-
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…
-
Tranfer of Ownership Issue
We are having trouble transferring ownership. I had a user transfer her ownership to me but it still shows her as being the owner on my end. When she goes to the smartsheet it shows me as the owner. Any suggestions would be helpful!
-
Cross Sheet Reference Unparseable
I am trying to use a COUNTIF statement to reference another sheet and count the number of "V" s so I can create a metrics sheet for my DashBoard Creation. I have attached a snip of it below but all i get is #UNPARSEABLE when i try it. I must be missing something, but I am unsure as to what. Received the #INCORRECT ARGUMENT…
-
automatically move date from one column to the next
I wondering if there was a way to move data from on column to the next when information is inputed into another column. For example if I create a column in front of wk 1 allocation% and input a %. I would like week 1% to move to Week 2, week2 to move to week 3 and week 3 to move to week 4. Week 4 can just go away or I can…