-
Status Circle Automation
Hi, I am using status circles for a high level status report. Is it possible to automate the 'Overall' Status Circle based on the colors in the other measures (budget, timeline, scope, KPIs, value). For example, if 4-5 of the metrics are green, Overall is green. If 3/5 are green, Overall is Yellow. If 1-2 are green,…
-
Find the row with the earliest Created (Entered) date that matches certain criteria
This one was a challenge. I thought I had it solved, but an erroneous value showed up, necessitating taking the formula back to the drawing board. The requirement: Show me the oldest Bill of Lading number that does not have a status of "Closed" or "Canceled." In another cell, show me the full Created date and time of that…
-
Need to set up column formula with =SUM(CHILDREN()) in one field
I have parent rows set up where it's always have "Total" in one of the fields How do I set up column formula to calculate CHILDREN rows each time under PARENT row? Currently it's only working with cell formula as =SUM(CHILDREN()) but I would like this field automatically updated every time I add parent and children rows.
-
Converting a text date: Thu, Aug 12, 2021 into real date
Hi Everyone, could anyone assist me with converting a text date column formatted like this: Thu, Aug 12, 2021 into a Date column? For example, I have two columns. text date column where I am importing data in this format: Thu, Aug 12, 2021 Real date column that forces a "real date" I know I can use the…
-
Task Overdue
Dear Community, Can someone please help me to correct my formula here . I want to show that if the due date is over and the task status is not marked Completed or Cancelled it should show as a Overdue.
-
Unique Dates
My team uses SmartSheet to log daily quote entries. I have created a separate sheet to tally their monthly quotes/sales and other data. I have a column on the above-mentioned sheet that I would like to tally the number of "days worked" based on the dates entered (COMPLETED) for each quoter (IS), within the current month.…
-
Is there an alternate formula to the "EXACT" excel function?
I need to return a value, (let's say "Yes"), if the text in a cell is all CAPS. Is this possible in Smartsheet since the EXACT function is not available? Thanks in advance for your help!
-
Count how many times a multi-select value was selected in a cell range or column
Hi, I am trying to count how many projects from another sheet has a specific OKR value selected in a multi-select dropdown column. Example: There are 4 projects, all of which could be assigned to a single or multiple OKR values. I need a formula to count the number of times, e.g. 'Improve Operations Efficiency', was…
-
Countif formula using date column
Hi there. I am trying to enter a formula into Sheet Summary for finding Completed/Delayed/In Progress tasks (from "Status" column) that fall in each fiscal quarter. I understand I should be using the countif formula for each of the statuses using the End Date column and the Status column, but I can't figure out how to set…
-
Match resource in sheet 1 to resource in sheet 2 and then enter start and end date
Hello Smartsheet Gurus I have sheet 1 that has the names of people and a second sheet with those names throughout let's call that column assignee. Next to the assignee in sheet 2 is a column start date and next to that is end date. I want to bring the minimum date out of the column for each resource and max date for the…