-
alert when someone fills out form
Hello, Is it possible to get an alert when people fill out a form? Thank you, Debbie
-
Hyperlink in a Request Update form
I am looking to see how I can insert a Hyperlink into a Request Update Notification.
-
Keeping cell with a formula even if its blank...
Hello... I've taken over SmartSheet from my predecessor in my workplace. I have over 30 different process steps in the Due Date column that work off the actual date for a writer's task process. The two columns of information are Due Date (1st Column) and Actual Date (2nd Column). How do I keep the formulas in the (30)…
-
Hyperlink
Is there a way to include a hyperlink in an update request when they open the update form button?
-
Highlight a Completion Date on the Calendar
Hello All, I'm looking for a way to highlight a particular date so that it shows in a different color (something like the red shading that already marks holidays). I want it to be visible on all rows so that I don't need to scroll to the bottom or top of the schedule to see what the target end date is. Has anyone found a…
-
COUNTIF # INCORRECT ARGUMENT SET
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. =COUNTIF([BV App ID (1) Status]2, [BV App ID (2) Status]2, [BV App ID (3) Status]2, [BV App ID (4) Status]2, [BV App ID (5)…
-
Checked and unchecked box
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 appreciated.
-
Feature request: Cell Linking still linked when to you click 'Go to the Sheet'
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 me SheetY (exactly where my site is linked) but I can't download the attachment from this preview screen, then when I click…
-
INDEX and MATCH #invalid value error
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 to the right and return the value from the same column in row 2. (Row 2 was created to replicate the name of the column…
-
IF ERROR Formula when trying exclue zeros from average
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 shortly). I have a child row (green) for each quarter, and then grandchildren rows (white) for each work week. The child rows also…