Can anyone help me out here.
My dynamic view page rows are not fully highlighted, from the 9 fields it only highlights 4
I cant find anything about this online so i post it here
Hi @Mike matthys
When we explored DV I noted too some highlighting was lost, I put this down to the way conditional formatting works on hierarchy, you may find other conditions are overriding in these 4 columns. Hope this helps.
Forever forwards Backwards never.
Just adding this for if anyone struggles with it
if you set a static color in your grid that field will not get highlighted in the dynamic row
you could use the show/hide formatting within dynamic but not something you allways want
so i solve this as followed :
select all your columns in your grid, select background color and set it to automatic
then setup your backgrounds as conditions
youll see that the whole row now will get highlighted in dynamic view
ez pz, but could be easier :D
Create and edit formulas in Smartsheet
Formula combinations for cross sheet references
Smartsheet functions list
Hi, I am wanting to display multiple vlookup results from a separate sheet into 1 cell. Example: Cabling Allocation Sheet, where we input an allocation to a text name "ECC" which can be multiple cables in the same run. Requirements Sheet - Need the output to be "115, 116, 117" (I have manually written them in at the…
I am reaching out to seek your assistance regarding an issue I'm encountering while calculating the number of surveys completed on each day of the week (Monday-Sunday). Despite various attempts to identify the correct day of the week using functions like DAY, WEEKDAY, and DATEONLY, I am consistently facing discrepancies…
Hi everyone, I have one of those pesky formulas that is giving me a hard time. This is for a Summary Sheet I'll use to build a dashboard so I'm referencing another sheet with the data. Here's what I am trying to pull...Count if the following is true: 1) Project name is the same as the project in the summary sheet 2) Month…
©2024. All Rights Reserved Smartsheet Inc.