-
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:…
-
Notify an assignee that the predecessor has complete his task.
I want to use smartsheet as an international project management tool. One thing is driving me creasy. I want to send out a notification to an assignee if the predecessor task is completed. Please find attached a screenshot of my scenario. The task in row 27 needs row 25 & 26 to be done ( active checkbox in column "done").…
-
Linking Construction Program line items to relevant task lists
I'm working for a design and construct fit out company and we're looking to invest in control center and I'm just looking at the configuration of the project workspaces and need some ideas for the following scenario.... Each project has a construction programme which is shared with the client. Within that program there are…
