Hello Smartsheets Community! I have another dilemma with one of the formulas some of you help me with. I was asked if there was a way to write the formula in the scheduled health column so that even at 0 % Complete that the schedule health ball changes to yellow when the end date is in range of the part of the formula that…
This feels like a dumb question. I'm trying to get a count of total "To Do" items in the entire Status column from the Team SCRUM: Communications sheet. This function is working fine without the cross-sheet reference, but nothing I've tried is working to correct the issue. The formula is as follows: =COUNTIF({Team SCRUM:…
Error with the No.of days due column. If there is an automation set to send an email whenever the number hits 14, the value in this column keeps getting changed whenever a new row is added. Based on the formula, it changes to 14 first and then realizes it isn't 14 and changes back to 13. Due to this, repeated emails are…
I have been able to piece together a formula that is mostly working and I need some assistance to get the final piece of it. I have a [Calendar Week (1-52)] column that is mapping a date to a calendar week. It successfully rolls over once it hits 52 and resumes at 1. I need to now map that [Calendar Week (1-52)] column to…
Hi, I have several tasks Smartsheet's to manage different projects. In order to avoid keep checking each Smartsheet for due dates, I would like to have a "Summary" Smartsheet that brings only tasks that are about to get due. How can I do this? Thank you
Hey there, I would appreciate some help. I've tried multiple formulas and can't get it right and hope you can help. I have a summary sheet which i am referencing a sheet to gather the total active projects for a department. There is a dept column and a status column. I created Dept_Ref where both those columns are…
Hi there, I've been combing through the posts and not finding exactly what I'm looking for...so reaching out to the experts for some help. Below is what I was hoping to accomplish. Any help would be much appreciated. Thanks, If Status is Complete then ball color should be Green If Status is Not Started or In Progress and…
I am trying to get the total value for a column and the math is completely off. has anyone encountered this? all i am doing is a simple sum. the total should be 703 not 595
Hello, Can you help me with the formula for "Time Spent" Column. I need to calculate how long it would take to process the order. Sometimes we process for days. I need to know how many days, hours or minutes. Thank you so much.
I need to sum the Story Points from a different sheet when the Component column value is 'UI' and the 'Issued Added after Sprint Start' column is checked. My formula is =SUMIFS({Mandalores Sprints Story Points}, {Sprint Name}, Sprint@row, {Mandalore's Sprint Data Issue Added}, "true", {Mandalore's Sprint Data Component},…
Create and edit formulas in Smartsheet
Formula combinations for cross sheet references
Smartsheet functions list
I want to use Project Name and Resource name as a criteria to pull hours worked into a different sheet. Please help.
Hi all, Hoping to get some help with a LOOKUP/COUNTIF formula. I'm trying to create a grid that counts issue location by month. I've created this column in the source sheet which is the range for the VLOOKUP. The sheet that this information needs to be pulled to: I'm struggling to create a formula that will count each…
i need a formula to find todays date between the start date and end date, then provide the current sprint