-
How do i count the number of times a status changes
I have a ticketing tool on smart sheets with a status column. the status can change from complete to reopen to complete and reopen again. I want to measure first call resolution, so how do I count the number of times the status in the row changed to re-open. Thank you for your assistance in advance
-
Formula to extract an email from a text string cell
Hello Smartsheet Community Friends! I am looking for a formula that would allow me to extract just an email address from a cell that contains text. Example, the cell in column "Notes" might contain: 'blah blah words blah myemail@email.com more words blah blah' I am looking for a formula that would help me extract thatβ¦
-
Count Dates in a cell
Is it possible to count the number of dates (mm/dd) that show up in a cell? Would the format of the dates need to include a year as well? In the example below I have two dates in the cell. If this is not possible, how would I count the number of dates in a date column
-
Overall health of a project
I have a sheet that tracks multiple projects. Each project has multiple tasks. Each task has a health column. I would like to create an "overall health" column that looks at the others and assigns the most critical health. In this case the most critical would be Red (overdue), followed by Yellow (warning), then Green (onβ¦
-
If one cell doesn't match another cell value, then notification send out
I have a condition where if a contact in Assigned To cell is different than the contact in Created By cell all in the same row, then send a notification to the Assigned to that the row has been assigned to them. They don't want notifications if both cells are the same contact. Thanks!
-
I want to count a cell if it contains any kind of text "*"
Hi there, I'm trying to find how I can count how many times a cell contains anything within a column. I know there's no wildcard like "*" in Smartsheet. Is there a workaround without inserting a specific text? I'm trying to replicate the formula below from Excel into Smartsheet. =COUNTIFS({Column X}, "Purple", {Columnβ¦
-
Need a formula, automation is able to do my task
When Assigned To changes in Task that contains "CCM Initial Checkout"(row 4) change Status in Row 3 to "Completed". I only need it for these rows/cells, cannot have the entire column doing this. TIA!!
-
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.