-
How to reference entire column from another sheet
Hi, I'm new to smartsheet and i would like to know how can i reference an entire column from another sheet, no criteria needed. I just want to return the data from sheet 1 column 1 to sheet 2 column 1, is there a simple way to achieve this? I have tried to use =INDEX({SHEET 1 RANGE 1}, 1), it will only return data from the…
-
Timestamping
Hello. Is there currently anyway to do timestamping in Smartsheets? For instance, timestamping a cell when a tick box cell is ticked? Thanks Andrew
-
Send an e-mail when a box is checked?
Hello -- Very new user here. I have a general technology knowledge, however, I'm having a logistical brain fog at the moment. Could I use an IF THEN statement to send an e-mail notification when a Box is checked? paint drawing (don't have any other fancy program on my work laptop haha) for explanation. Thank you!!
-
How can I edit the result of a VLookUp or Join(Collect) Function?
Hi Everyone, I'm currently trying to reference cell values from one sheet to another. The values in the so-called "Database Sheet" will always remain the same. The main sheet will need to reference the values in the Database Sheet through the use of a Join(Collect) Function or VLookUp within the main sheet. Fortunately,…
-
Is there a way to link attachments across sheets?
I have attachments on rows in one sheet. Right now, I download that attachment and upload it to a row in a different sheet. Is there a way to link the attachment so that when I put it in Sheet 1, it will appear in Sheet 2? Other than downloading and uploading it of course. Thank you for any insight!
-
Copy a range of cells under a parent or ID number to another sheet
We have a wide range of purchase orders which can be created for any job from 1-50. There are about 6 different PO groups I would like to pull data from and assign them to their individual projects in their corresponding rows. Is there a function where I can call the parent and it will copy the parent and children…
-
Cell Linking to create a drop down list
Has anyone been able to use current functionality in Smartsheet to link to create a drop down list, from an existing filed in another sheet? I am looking to do this, as the other sheet will contain a listing that is the source that is updated, and I would like for my selection on my drop-down list to remain in sync. I can…
-
Help! Refrence using =INDEX in a drop-down single select
Hi All, I'm new to Smartsheet, id like to use =INDEX formular reference to reference another sheet cell. when i select a single option in the drop down it will reference that cell.
-
Linking Errors
Hi When I link out from my smartsheet to individual schedules it does not show the link anymore until I refresh and then it crashes. I get this error - see screenshot
-
Unparseable Error
I'm getting an error #UNPARSEABLE for the following conditional formula that sets Red, Yellow, Green, Blue symbols per combined conditions of [End Date]'s proximity to "TODAY" + Status Condition (Not Started, In Process, Complete): Formula:…
