-
How can I add a colum with the Estimated percentage of progress
Currently, I have my percentage of " completed work". However I would like to know , how can I calculate the " estimated percentage of progress". I mean. Today in one activity I have as "%Complete" an 80%, however accoring to my work plan by today in theory I should have that task at a 100%. How can I add that column to…
-
Restrict "Date" field to Saturday only
I am looking to restrict the Date field in a form to only a Saturday, is this a function within Smartsheet?
-
Invalid Operation
Hello, I have a sheet tracking inspection dates. I have a status column with a formula that assigns a status based on when the expiration date is in relation to the current date. The status column is populating properly when there is an expiration date value in the "expiration date" column. However, for rows that have a…
-
Fast status updates based on parent cell
I would like to make our status updates faster by utilizing the parent/child cell(s). If the user changes the status in the parent cell (dark grey line) to "Completed" then the child and grandchild cells would change to completed. If the user marks the child cell as one of the following statuses then the grandchild rows…
-
Formula Needed: Past due indicator Y/N based on % to Completion and Target End Date
Hello All, I need assistance writing a formula that does the following: If column % to completion = 100%, then column Past Due (Y/N) will = N If field % to completion is < 100% and column Target End Date is < Today, the Past Due (Y/N) will = Y otherwise N Any assistance is appreciated. MJ
-
Formulas with multiple inputs in smartsheets. Help needed!!
This has been a challenge for me to figure out using the smartsheet platform. I am developing what is essentially a big calculator. The formula that I am trying to implement is: [($26,000 * DTH) + (Risk R * Repair Cost) + (Risk A * repair cost)] * frequency). In this database, each row represents an additional input. The…
-
How to average non-adjacent cells
I'm trying to average non-adjacent ranges. I've tried =AVERAGEIF([Range:Range],[Range:Range],"<>0"), but get an error each time.
-
JOIN Circular Reference Error
Hello, I am attempting to JOIN two date columns, and keep getting a #CIRCULAR REFERENCE error. My formula: =JOIN([QAM VOD Shutdown Date]@row:[Ending Date]@row, " - ") Can anyone make a suggestion why this keeps occurring?
-
Extract email address in a text
Hi, I would like to extract an email address in a text, knowing that the email address could be in at the beggining of the text, in the midldle of the text, at the end. I have tried formulas with MID, to extract what's before and after the character "@" but I can't find a way to do it on smartsheet, without TRIM ou REPT.…
-
Help. COUNTIF
I have been trying to find the correct formula for my Smartsheet. I need to create a count of how many people have been approved, denied, in progress, or have an incomplete application. I need to pull this from another sheet. Any ideas?