-
How to reference the <CELL ABOVE>
Is there a way to reference the cell above? example: =IF(logical_expression, value_if_true, <CELL ABOVE>) The simple way is to reference using [COLUMN_NAME]2 (the number being the current row number minus one). But this is broken anytime a row is deleted, which happens frequently on our sheet. I have tried adding an…
-
Link limits regarding Vlookup
My question is regarding this statement: "There's a limit of 25,000 inbound cells that can be referenced from other sheets into one sheet in total." If a cell on the inbound sheet is reading a range from another sheet, do all the cells in that range count against the inbound sheet, or is it just the one cell that is…
-
Notification - Tech Issues: Anyone else not receiving em notifications today? 05/22/18
Been using SS since 2016 and have never had a delay send or non-received notifications. My entire company today is not receiving the regular email notices. Is anyone else experiencing this issue today (or if in past, how was it resolved)? Note: I have contacted our Account Rep and ensured that the domain isn't blocked at…
-
Calendar View
New to Smartsheets but I've created individual project sheets and I've taken key production data, specifically dates and linked them to a Master Production Schedule sheet. I've added the customer name as the parent and each stage of production as a child which allows me to see customer names and all of the steps in…
-
VLOOKUP Annoyance
Does anybody know if there is a way to rid of this annoying fly-out when viewing a sheet that has some references in it?
-
Using predecessors to dictate duration
Hello, I have a line in a sheet that I would like to start when another line starts and end when a different line ends. For example, I have 4 lines in a sheet: Line A, Line B, Line C, Line D. I want Line A to begin when Line B begins and end when Line D ends. I want the duration to be malleable and change automatically if…
-
IPhone 7 Home Screen - Webform
How do I add a webform to the home screen of an Iphone 7? Is there such a feature?
-
Deleting Entries Made Through Forms
I entered some test entries through the "Forms" function and now want to go live with the sheet. It is not allowing me to delete the test entries. When I delete them, they come back when I refresh. Is there a way to delete entries once they have been applied to the Smartsheet sing the form function?
-
Project plan updates and forms
I am using SmartSheet for a project implementation and want to issue alerts using the Forms functionality. How can I include predecessor information for each of the tasks I want owners to update via Forms? Currently, I can provide the users with a listing of all tasks, however they may relate to a predecessor task that…
-
Reports - pdf or Excel ?
I send out weekly reports of our products to our customers with their expected delivery dates (which can change frequently). If an email address needs to change I am unable to see the original format of their report, so have to guess their preferred format - pdf or Excel. Short of sending copies of each report to myself…
