-
How to have child rows displayed using parent data
Hi all, I have a complex sheet which is efectively a "to do" list. Thanks to the community I have it working pretty well as I want and am very happy with it. To polish the sheet, I would like to achieve the following: I have my todo's organised by project then category. For example, I have a column called "project" which…
-
Column Average
Hello! I am trying to calculate the average of a column. It seems like this should be a very simple task. I'm typing =AVG then referencing the column I need to average from another sheet. It generates the following formula =AVG({Employee Reviews - PFP Range 7}) However, when I hit enter, I get a #DIVIDE BY ZERO error. Any…
-
Counting and applying "color status" for parent/children rows
I have overall Annual goals (purple lines) with sub projects that fall into a particular category. I then have subtasks that fall under the corresponding item (identified with an alphanumeric task number). I want to be able to summarize (on a dashboard) a couple of things: the task health of the project level (task 25 with…
-
How to stop Alerts being triggered by TODAY() formula
Hi Everyone, This is my first post on here and hope someone can point me in the right direction. I have a formula cell which references TODAY() in a certain IF criteria. I also have several alerts going to various users which are generated if cells are added or changed on specific rows (including an alert to myself to show…
-
Row or Record roll up and multiple forms or sheets
I have been attempting set up a relational database for multiple client use. This database should track records (rows including child rows) as it progresses through different phases. Projects may stop periodically and should be searchable and may be re-started later. I have tried using 3 column relational connection to…
-
Counting Check boxes when Checked
Hello, I would like to find a way for a way to count the check boxes when they are checked. Ideally, I would like formula that allows me to know what date it was checked. I'm not sure if the modified data column can do this because I do not have sufficient data at the moment. Another solution I'm thinking is possible is if…
-
Count "New Entries based on a date" to a dashboard
I am adding new entries to a sheet daily. I need to know on a given date how many entries were added to the sheet. I need to be able to adjust this daily. I have created something on a google doc that works very well but I can't seem to duplicate it in smartsheets. My goal is to have this count reflect on my sheet…
-
Joining Formatted Cells
Hello All, First time caller...Is it possible to join cells where text in those joined cells have different colors and have the joined cell retain all the various text colors? I've tried =Cell1 + Cell2... and =Join(Range) and both return combined text in default black text. Thanks in advance for your feedback. DT
-
Weekly Tracking for a Dashboard
I have a grid where I am trying to lookup from a grid that people can log issues on. The first lookup is the date range, we want to count all issues within that date range. Then we only want to count by the "Field". On the log it is the column titled Field it is a dropdown of those fields listed on the Weekly trend grid as…
-
Operators documentation
Where can I find documentation for which operators Smartsheet supports in formulas? Note: I am looking for documentation of operands ("+", "&", "<", etc.) not functions (SUM, INT, MAX, etc.). For example, here is the page that documents which operands are supported by Excel:…
