Formulas and Functions
Archives for March 2019
Discussion List
-
Formula with COUNTIF and CheckboxIn Formulas and FunctionsI have this working formula: ="Unit 2G is " + ROUND((COUNTIF([Unit Name]:[Unit Name], "2G") / 14) * 100) + "% Completed" 2G could also be 3G, 4H, and 2H. (Dropdown selection list) I have a checkbox colu…
-
Weekly Tracking for a DashboardIn Formulas and FunctionsI 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…
-
Countif after certain dateIn Formulas and FunctionsHi! I'm trying to create a formula that will count the number of rows that have a "Delivery Date" after 1/1/2019. Any row with a date prior to that should not be counted. I also do not want blank rows counted. In the screen cap…
-
Symbols Formula. How do I make a symbol depend on two other columns?In Formulas and FunctionsHello! I am trying to make a symbol formula that will become "1" (red flag) IF the Start date is in the past, AND if a dropdown list DONT show "Done". Anyone that has this formula or knows how to write one? Kin…
-
Total Sum By Month selected on DropdownIn Formulas and FunctionsI need to be able to select to view the total cost of children by a certain month. Currently, I have the dropdown values of all 12 months. I have the formula to the right of the dropdown calculating the total cost recorded for each child.…
-
Check if one contacts column matches anotherIn Formulas and FunctionsI want to set up a notification for when a row is modified by someone NOT in a contact list column of "assignees". The idea is that if someone not in the assignees cell modifies the column, then I would notify the assignees. I w…
-
Need report that only shows fields that are NOT blankIn Formulas and FunctionsHi, new to Smartsheet but enjoying it so far. I'm building a report from multiple sheets that would ideally be a master list of all the rows that do not have a blank cell for one specific text/number column. The values within the column wi…
-
Countif but only if?In Formulas and FunctionsSo I am trying to count the number of times a person worked on a specific task. I have various "types", each person might have worked on the task in a different role (Lead SME, SME 2, SME 3), and then I have a check mark whether…
-
effort and allocation-based timelines?In Formulas and FunctionsWe have a small team, with each member having very a specific area of expertise. As such, our timelines are defined by prioritization of tasks, dependencies, effort, and resource allocation. I want to enter my tasks, set their dependencie…
-
Formula Help!In Formulas and FunctionsHi, I'm new to Smartsheet and the community. I am trying to trigger a flag on my sheet to alert me when: - The status of my project is not complete, 5 days before the end date - The status of my project is in progress, but less tha…