-
Need to remove leading zeros
I have a column that represents 'Store #'. Store #'s are 4 digits, i.e., 0001 or 0010 or 0100 or 1000 This becomes a bit of an issue when sorting the column. I am creating a helper row for purposes of sorting and want to remove the LEADING zeros, however, am having trouble figuring out how to accomplish this. Thoughts?
-
Fill in a cell based on another cell's value?
Hello, I'm tracking participation of a program on my sheet as a "participation %" column. There is another column called "participation status" to make it easy for the managers to know if their employee is on track with participation or not. I'm trying to set up the participation status column so that if the participation…
-
Creating Formulas for Status, and Task Health to send Email Notifications
Hello, Everyone I need help with my syntax on some formulas and sending email notifications. • Status ○ If the %Complete is 0%, Status = Not Started ○ If the %Complete is between 1%-99%, Status = In Progress ○ If the %Complete is 100% = Complete § Questions: What if the task is no longer needed? In MS Project, we would…
-
Please help me convert an Excel formula into a Smartsheet formula
The following formula works in Excel and I'd like to recreate it in Smartsheet: =if(C2+1, D6) In Smartsheet, my column C is called Session, and column D is called Training Date. The Session column includes numbers only. Please let me know if you need additional info, thank you!
-
Help with formula
I am wanting to count the number of drop down items selected in a cell, but I only want it to count in the cell for a specific row. This is the sheet that i want to count the number of dropdown items from. This is the sheet that i want the formula written in to return an output. Currently I have =IF(HAS({centers},…
-
Stuck on Multi-criteria countif function
Hello, I am trying to find active pilots at risk by using countif to find the following in a range: Planning Pilot Execution Pilot Summary Approval to Launch That have a status of red or yellow Is there anyone great at these who can help? This is what I have so far: =COUNTIFS(Sheet - Pilot and Readiness Pipeline - Pilot1,…
-
Need help calculating estimated completion date for production while excluding weekends
Hello Smartsheet Community! I have a project I am working on for work, and I am struggling with a formula to calculate the expected date of completion for our production orders based on a few criteria. A few things are missing that are confidential, but I have attached a picture of a practice spreadsheet: Please note: a…
-
How to get the formulas to correctly count the completed tasks?
The current formula counts every task for the total. =COUNTIF(DESCENDANTS([Planning Done]@row), 1) + " of " + COUNT(CHILDREN([Task/Topic]@row)) + " Done" I have been trying to get it to only count when all subtask from its proper row have been completed. There are 4 tasks and over 60 subtasks. When the subtasks are…
-
COUNTIFS Error
Here is my formula: =COUNTIFS({All Qs}, "Yes", {Hospital Match}, [HFMC Score]$15, {Month}, [Primary Column]@row) I am getting an #unparseable error. Each component works using COUNTIF. Do you see something I don't see. Thank you, Linda
-
Formula to show duration days in Months, Weeks, and Days
I have a duration in days column and I need to show what that duration is in months, weeks and days. Assuming a month is 30 days and a week is 7 days. The attached blue columns are what I want to calculate with a formula (manually entered now to show what I want to see). For example, if something is 38 days, I want it to…
