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!
2 Likes
You can use only one boolean by checking if not empty, and changing column type from boolean to text
1 Like
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
Configure an if-then-else column as follows:
- If X is greater or equal to 90 , then black
- If X is greater or equal to 76, then red
- If X is greater or equal to 46, then orange
- If X is greater or equal to 0, then green
- Else grey
thank you soo much
but 1 more question
how do i add the coloured dots? what option do i choose to use the dots??
have temp used text to show the colour but not sure how to go about the dots.
sorry only new to this
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
1 Like
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).
1 Like