-
Is it possible to have data automatically inserted from an image by image recognition?
I see that Microsoft excel has the ability to use OCR to insert data from an image so I was wondering if it was somehow possible to integrate a working version of this into a Smartsheet. Thanks in advance.
-
Simple question, How do I automate my RAG status column based on dates?
This is for contract management circumstances. Green=Contract is active no issues Yellow= Contract is due to expire in 90 days (I have a column with the contract expiration date in it) Red= Contract is expired (Again this would be based on the value in the contract expiration) I checked the Automation and there doesn't…
-
Can you auto populate created by via form?
Is there a created by workflow for forms for whoever submits? Been looking to add this function but whenever I try to do this via the sheet it only gives me created by = web-form@smartsheet.com
-
Automation Testing
I am currently working through some automations and some different ideas on how to get them to work the way I want. However, the particular automation that I am working through (as far as I can tell) only works when it is run at a particular time (hourly, daily, when a date is reached, etc..). Is there a way to test these…
-
Issue with Date column with formula =today()
Hey Smartsheet community Has anyone encountered this issue where the Date field with the formula = today() is not updating on its own until and unless you open up that sheet? I have a sheet which powers my Dashboard and I need to open up this sheet so that the date column reflects todays date and hit save, else it will be…
-
IF with INDEX MATCH
Hello, I would like to check a box on one sheet, if a box is checked on a different sheet, matching certain criteria. This is what I have so far: =IF(INDEX({Current Estimates Range 1}, MATCH([Project Name]@row, {Current Estimates Range 2})) = 1, 1) If the Takeoff Information Column is checked on this sheet, then check the…
-
Merged: Automation Action to calculate a Variable Value
This discussion has been merged.
-
Merged: Automation Action to Record Date AND Time
This discussion has been merged.
-
Weekly Automation occurred day late, why?
Hi I am setting up a system to automatically track the weekly change in a log, and requires more than one sheet to pull off. Timing is very important to ensure the right information gets copied/cleared/used in formulas. However most of the automation went off without a hitch is seems, except one step failed to trigger at…
-
How to display "closest matching" rows based on an "input" row?
Hello all! I've been building out what is essentially a database to track information related to customer orders of a specific product. The product is essentially custom tailored firmware - specifically, automotive engine tuning files. Most of the information is provided by a customer through a form, some is manually input…