How to get highlighted cell reference using API call?
I am working on automation project and we need to get yellow highlighted cell reference details using API call. I have to get recently updated cell (for example the cell that has been updated today is highlighted in yellow).
Answers
-
Hi @sujitha
There isn't a way to specifically get rows based on Highlight Changes via the Smartsheet API.
In theory, you could look at the cell history of every cell and filter down to the cells that were updated within the same time frame that Highlight Changes is set to.
Another option would be to use the UI to download the Activity Log for a specific timeframe (see: Track the History of Changes with Activity Log)
Cheers,
Genevieve
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 64.2K Get Help
- 419 Global Discussions
- 221 Industry Talk
- 461 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 142 Just for fun
- 58 Community Job Board
- 462 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 299 Events
- 38 Webinars
- 7.3K Forum Archives