Show Google Sheets text/cell colors in Table
Good day everyone
I am just wondering if there is a way to pull the cell or text color from Google Sheets into a Domo Table?
We have a google sheet that is updated manually with scheduling information. If an appointment is scheduled then the date is input with red text color, once the appointment has been completed the text color is changed to black to confirm it has been done. This google sheet is then broken down by Domo into a table to send as a status report to each technician.
So back to the question, is there a way to do this with just text color? We are willing to change the process if anyone has any ideas.
Any help is appreciated!
Thanks
Best Answer
-
You won't be able to pull in the color however you can tweak your spreadsheet and add an additional column to hold the status (You can go one step further with Google Sheets and restrict the values within the column to be only selectable from values in a list you specify to enforce data integrity). That column will then get imported into Domo where you can utilize it within a beast mode to color the original text as you outlined.
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**1
Answers
-
You won't be able to pull in the color however you can tweak your spreadsheet and add an additional column to hold the status (You can go one step further with Google Sheets and restrict the values within the column to be only selectable from values in a list you specify to enforce data integrity). That column will then get imported into Domo where you can utilize it within a beast mode to color the original text as you outlined.
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**1
Categories
- All Categories
- 1.9K Product Ideas
- 1.9K Ideas Exchange
- 1.6K Connect
- 1.3K Connectors
- 303 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 2.9K Transform
- 104 SQL DataFlows
- 637 Datasets
- 2.2K Magic ETL
- 3.9K Visualize
- 2.5K Charting
- 763 Beast Mode
- 65 App Studio
- 42 Variables
- 709 Automate
- 184 Apps
- 460 APIs & Domo Developer
- 54 Workflows
- 11 DomoAI
- 39 Predict
- 16 Jupyter Workspaces
- 23 R & Python Tiles
- 401 Distribute
- 116 Domo Everywhere
- 277 Scheduled Reports
- 8 Software Integrations
- 134 Manage
- 131 Governance & Security
- 8 Domo Community Gallery
- 44 Product Releases
- 12 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 111 Community Announcements
- 4.8K Archive