I have a series of cells that aren't continuous, that I Ctrl/clicked into the formula. I want to count how many are Status N/A. I can't figure out why I am getting the Incorrect Argument Set error. =C…
I need the amount from 1 column to appear in another column if the box between both columns are checked. Please write out the formula so I can copy and paste. Please see the attachment. Greatly apprec…
So when your linking cells across sheets, I'm trying to link SheetX with SheetY (which has the attachments I need), I can link the site names between the sheet, when the preview screen pops up to show…
Hi! I'm trying to apply a formula we got to work in Excel to our Smartsheet. The goal is to look at a range (Column "1" through Column "Column64") in a single row and find the non-blank cell farthest …
I am creating a sheet for PM weekly time tracking. The top parent row (blue) is YTD roll up of total hours, as well as a column for average weekly hours (<---- this is my issue but I'll to that shortl…
Hi, does anyone have a contact number in the UK that works? my account & my whole company is locked out & asked to upgrade when we already have.... this is very urgent!!!
I use the Card View for quickly creating tasks and tracking their status/state. I'm trying to see if it's possible to take this further and populate the Start Date and End Date fields when the task fi…
Hello, I am trying to find a way to link rows between sheets, but the 2nd sheet should only show the rows from the 1st sheet with a checkmark in one of the columns. Sheet 1: list of skus with descript…
I recently noticed that all dates including columns that are hidden are showing with my automated reminders. I have a number of calculated dates that I don't want to display. However, all of them now …
I am looking for guidance as I feel like I am missing something really simple. I would like to be able to have a title(label) included in my COUNTIF statement. This is the total count formula I have f…