-
Formulas for visual symbols
Are there any formulas specific to visual symbols to simplify summary data for parent rows? I have a RYGB status for activities within a project and would like to be able to summarise the 'worst' status in the parent rows. For example, if three activities are green (on target) and one is yellow (slight delay) then the…
-
How to order rows from a Auto Number/System column?
Hi I have a sheet A (SA) that is populated by copying row from sheet B (SB). When a new row is added to SB, I have a "Created" column set up as Auto Number/System column (System-generated column =Created (Date) ) which allows me to identify when the row has been added. I want to filter the rows based on the dates they have…
-
Percentage (%) complete formula - cancellation date
Hello, Due to COVID 19 we have had to cancel some courses up till the end of June. I need help to make a column with a formula to calculate the percentage of the course that was complete at time of course cancellation (any date between start and end date) given columns with the start date, end date and cancellation date.…
-
Formula link RGB Symbol to automatically update according to Number
Good Morning I have another formula question, i was hoping i can get some help. I would like to make the below RGB Symbol change according to the number below. E.g. I would like the below yellow Symbol to change when the -0.2 number changes The rules i would like to set are: Green: 0 and above(anything positive) Yellow: -1…
-
Nested IF formula to return a symbol based on a range
Hi, I am trying to write a formula that will look at the value in a cell and return a RYG dependant on the value being either below the value in another cell, within a mid range or above the range. I think the issue I am having is in relation to the range section, do i need to enter the range value into the formula rather…
-
How do you sum totals of a column that include "No Match" cells?
Hello, I have been trying to search online but can't seem to find the answer to my question. What is the formula to sum cells in a column that include some "No Match" cells? Much appreciated, Cheers
-
Drop down selections not appearing in form
Is there a know issue with this or is there a max number of selections with forms? I have a contact list of 3000 names and it is not appearing as a drop down in my form. Other drop down's I have are indeed showing up and I am doing nothing different. They are restricted to the drop down values. Also I tested and took out…
-
Showing Completion of tasks ON TIME: EARLY: LATE
I work for an air cargo company. I seek help with calculating the above. Here is an overview of a typical nights work out on the ramp. A load planner and cargo loading team is tasked with getting airplanes loaded and sent out on time every night. If they are early, great! If they are on time, great! If they are late, heads…
-
Logic and summary
Hi, We have 400 locations managed by approx 30 managers. I am trying to use logic to build a form that when manager 1 chooses their name they only see sites relating to them. To achieve this i have created columns with a drop down for each manager in my sheet. As these entries come into the sheet via form entries they go…
-
Need help with creating aging buckets.
Hello, I have the following formula in excel but it did not transfer to Smartsheet. Is there a way to get this formula over? =LOOKUP(F2,{-100,7,14,21,30,45,90,180},{"0-7","7-14","14-21","21-30",">30",">45",">90",">180"}) I am entering this formula in the column "Equipment Date Range" and validating the data on column "Days…