-
Auto populating Status of a child row to duplicate Parent Row
I have a project I'm working on where I want to auto generate steps based on the status in two columns. I figured out the formula for that. My issue right now is that without me manually entering/copying the status (I will normally not be in this sheet after it's developed) or having the user enter the status for all 6…
-
Adding Second Sheet to Countifs formula
The reference sheet for my COUNTIFS formal has maxed out the number of rows available so I created another sheet to reference. How do I add the second sheet to this COUNTIFS formula: =COUNTIFS({Next Follow Up Jun}, <=DATE(2022, 8, 31), {Next Follow Up Jun}, >=DATE(2022, 8, 1), {OM5}, "Stacy Redd")
-
Formula help for averaging data in 1 column based on criteria from 2 other columns
I need help with a formula that will average the total in 1 column based on 3 criteria of another column and 1 criteria of another column. To phrase better, I have a column of dollar amounts that I need to average based upon the sum of all values in that column. BUT, the values to sum are based upon 3 status values of…
-
Required completion time in hours between "dates" and in "hours and minutes"
Hello, I have two columns: Start Date and End Date. I also have Hrs, Min, and Clock available, as shown in the image below. Now I need the completion duration in hours between these dates, as well as the Hr & Min.
-
Extract date as date from date and time stamp
I am importing a date and time stamp (e.g., 9/3/2022 8:36:19 AM) and need to extract the date into a date field so Smartsheet recognizes the date. I have a formula to extract the date as text (i.e., 9/3/2022) in another column, but cannot find a formula that works to convert the month and day to two digits and converts the…
-
Need a formula for Business Impact Assessment
Hi There, I'd like to determine Priority based on Impact + Urgency/Probabiliy. Each using symbols (High Medium, Low) Does anyone have a formula I could use which will consider both entries for Impact + Urgency which can give me a result in Priority? Based on where they meet in the table below. Can anyone help me with a…
-
Nest WORKDAYS from TODAY into IF formula to return correct symbol
Hello! I'm VERY new to this, but I worked out my first nested IF formula to pull symbols based on Start & End Dates. =IF([Done?]@row = 1, "Gray", IF([End Date]@row < TODAY(), "Red", IF([End Date]@row <= TODAY(3), "Yellow", IF([Start Date]@row <= TODAY(), "Green", "")))) Logic... "Gray" IF task marked Complete "Red" IF End…
-
Mark Duplicates In Multiselect Dropdown Contacts Column vs Employee Names List?
Ok, we're making a labor schedule, and want to be able to note when and where someone is used multiple times so we can prevent overscheduling someone and ensuring proper manpower. With the above as an example, I want to highlight a cell in [Employees on Job] (multiselect dropdown contacts) column, when one of the values in…
-
Need Help with Formulas (Assigned To More than 3 Projects)
I should start off by saying I am very new to Smartsheets and have little experience. I am trying to add a formula(s) to eventually use conditional formatting in Ganett view to highlight the bars red if a employee(Assigned To) is assigned to 3 or more projects with overlapping dates per state. Is this even possible?? Here…
-
=totalfloat() appears to work, but not treated as a number??
Thank you SS for finally implementing the totalfloat function. I have implemented as: =TOTALFLOAT([Task Name]@row) It appears to work. However, here is my issue. I created a new Symbols (stoplight) column and I am trying to setup an IF statement to show green for more than 10 days of float, yellow 1-9, and red for 0 days…
