Formula with COUNTIF and Checkbox
I 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 column named: "Task Completed?" How would I use the working formula to not do the calculation until the checkbox is "Checked"…
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…
Countif after certain date
Hi! 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 capture attached, you'll see all but one populated row should be counted. Any suggestions on a…
Symbols Formula. How do I make a symbol depend on two other columns?
Hello! 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? Kind Regards// Hugo Martinwall
Total Sum By Month selected on Dropdown
I 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. But based on a different month, I want the value to change based on the date recorded…
Check if one contacts column matches another
I 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 was trying to set up a helper column that would calculate if a "Last Modified By" system column…
Need report that only shows fields that are NOT blank
Hi, 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 will vary widely but some will be blank, and I do not want to show the rows that are…
Countif but only if?
So 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 or not it should be included in the "tally". Ultimately, what I am trying to do would be if the…
effort and allocation-based timelines?
We 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 dependencies, effort in hours, priorities, plug in the resources and set their allocation, and…
Hi, 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 than 50% complete, 5 days before the end date The below both work individually but I'm having…