sorry I didn’t get your question…
where do you change (click) status?
i see column STATUS, but i cant find where do you click on it
in the patients section
with “is this resolved”
and you changing status column by clicking choices picked/resolved ?
ok… got it…
Change column status from boolean to text
create 3 columns in isuess sheet with single value of each color
than change if column
Just checking uzo
did you get how i changed columns?
Hey, that was not it But we resolved it by using two booleans and putting if else on status icon!
Thank you so much Uzo! Your replies really helped us with that!
Yes, I did that!
hey what can i do for the case where i need 4-5 options
eg
i need something for if its been
0-45 days (green circle shown)
46-75 days (orange circle shown)
76-89days (red circle shown)
90+ days (black circle shown)
and if possible
if blank (grey circle shown)
hope yo can assist
They are emojis, you can paste them in.
Depending on how the column is being used, you could also use an Image from Colour column to generate an image from the text.
Any further help on this ?
Not sure what to do cant work out how to even paste anything in etc
I already have an image in table for something else so can’t find emojis or option to paste anything
Did you figure it out?
Just as a side note, I’m curious about your “Days Ago” column…
I can see that it’s configured as a Number type, which suggests that either the values are manually entered, or perhaps they are calculated using a Spreadsheet formula?
Anyway, just in case you are not aware, it would be possible to automatically calculate that for all rows using a Glide Math column with the formula Trunc(Now-Date), where Now is the Current Date/Time, and Date is your “Date Last Worked” column (assuming that’s what used to calculate it).