-
Can you do if this then that for auto entry from drop down list
I want a column to chnge its value from a drop down list when a criteria is met. What I am after is a column that is titled "ready for invoice" and is a check box. I have another column named "currently assigned to"that shows the seperate departments on an account and it reflects which department is resposible for the…
-
Automation: Request an update but my contacts are not in a contact column
I'm working on a sheet that has a formula that is running an INDEX/MATCH to populate the Carrier Contacts based of the trucking company's Unique SCAC code. The fomula is working great now and I have the cells populated with the email contacts for the carriers. I am now trying to write an automation "Request an Update" but…
-
Auto-Refreshing Sheets/Grids - to auto update formula cells.
I saw a post in the community at https://community.smartsheet.com/discussion/auto-refreshing-sheetsgrids which had a similar question. But no answer was provided and the last update (from another member) was in Dec. 2018. Again, no response or answer was provided. I have a sheet, with formulas, to calculate today's date,…
-
How to create a future date based on a date in another column?
Hi, I am looking to create a formula in a column that automatically calculates the date of 12 weeks from the date of deposit column. Can someone please help with the formula? I keep getting errors. Specifically I would like the "estimated completion date" column to be the "date of deposit" column plus 84 days. Thanks! Keren
-
Smartsheets Down?
I am unable to access smartsheets from any of my devices. Is this just me or is anyone else also experiencing issues. Update: I found this link: https://status.smartsheet.com/
-
Left panel menu
I liked the tabs on top of the sheets. I could put them in whatever order works for me. I don't mind the "left panel menu" that we now have instead - but I DO NEED to put the list of sheets in the order that makes sense for me! Every time I need to open a different sheet, I have to scan up and down the list of 20 sheets,…
-
Barcodes count and verification
Hello all, I'm looking to implement a process where I can count how many times a particular barcode label has been scanned. This will help me to verify that all the items that belong to a single unit are leaving the workshop after going through the fabrication and painting process. Can you think of a process using…
-
calendar and linked registrations
Has anybody used SmartSheet to mass distribute a calendar with multiple events shown and connected independent links so people can select and register for each of the separate events?
-
Website Counter
Is there a way to add a counter to the Smartsheet Dashboard to count the number of times the dashboard has been viewed?
-
Finding Duplicates
Hello, I have several sheets. One every month with at least 2000 rows per month. I import the information from an outside source via Excel. Long story short, there is a high probably ability of getting duplicate information from the outside source. Once imported from Excel into Smartsheet is there a way to fnd & delete…
