Trending in Smartsheet Basics
-
Can I change the font color of the Sheet Name in a report?
Hi all, I am trying to change the font color of the Sheet Name in a report. Scenario: I have a dashboard which contains a report showing the Sheet Name as links which is what I want. I have also color formatted the rows from the data source sheets based on criteria (i.e., a project is a dark purple fill w/white font; a…
-
Filter for comparing dates
Trying to create a filter to only display rows when dates in "Max Obtained Date (LW)" column are greater than dates in "Max License Status Date (NMLS) column. Any ideas?
-
Read cell with comma as a number/value
Dear all, I have a column with numbers that can contain a comma. I need to do a sumif on this column, but Smartsheet reads this column as text, and therefore my formular does not work. I have tried different ways to convert the column to a number in another column, but I have not managed to find a function that works. I…