-
Display a date on parent row only when all children rows contain date
How may we fix the below formula for parent row so that it displays the most-future-date from children row after all children rows are filled with dates? =IF(COUNTIF(CHILDREN(), 1) = COUNT(CHILDREN()), MAX(CHILDREN()), 0) Currently, "0" (nothing) is displayed on parent row no matter whether there is/are dates in childrenโฆ
-
Automate color change on a Date-category cell
In attached scenario, is there a formula that will enable โTarget Dateโ cell turns to red color when it is smaller/earlier than โCompletion Dateโ? Inserting a Date category column and setting up conditional formatting gets the job done. I'm curious whether there is a simplier way. Thank you. Jon
-
Color parent row while any children rows becomes red
How may we construct a formula so that a parent row will be highlighted in red, if any of its children row becomes highlighted in red color? Thank you. Jon
-
Usage of [ ] symbols and ( ) in formulas.
Hello Smartsheet community: In the attached picture, why "Task Name" variable needs to be surrounded by [ ] symbols while "Cost" variable does not? Thank you. Jon
-
Linking cells based on matching criteria
I have two sheets, both sheets have a row of column IDs, I would like to dynamically match the column ID from one sheet to the other sheet and then update a row. Similar to the new Lookup fucntion that was recently released but across two sheets. Has anyone developed a solution for this. My only option is to manually linkโฆ
-
Creating a report, Not able to select column that exsists on sheet.
Hello, I use the same sheet frequently and change the title/calendar to fit the need of the project. I also use the same report, and generally just change the sheet the search is restricted to in order to generate calendars for sub contractors for the specific project. However, I'm having a strange error. I'm trying toโฆ
-
LOOKUP() Function Help
I'm trying to write a function that will determine the county of an address based on the city. So far, I have created a table with several counties forming the vertical axis and then a list of all of the cities in each county running along the horizontal axis. It looks something like this: County 1 City1 City2 City3 Countyโฆ
-
Is it Possible to See My Update Requests Across All Sheets?
My team and I have a lot of projects going on simultaneously. I send them update requests on a regular basis, but I can't seem to find a way to see all of my pending requests at once. For example, if I'm meeting with a Project Manager, he or she may have 10 to 15 different projects going on.... It would be great if I couldโฆ
-
How do you set Alerts based upon field values?
Desired Result: An Alert email is sent to the user name specified in the Contact List column when the status on that row equals a certain value. Example Layout: Column A is a Contact List drop-down Column B is a Status drop-down with labels of Planning, Contract Request, Complete Columns C - Z are various data fieldsโฆ
-
Enhancement Request: Show filter expression
Would like to be able to hover over a filter icon and have a popup advise the filter expression.