-
PMO Template
I am struggling with the PMO template and the Schedule Health column in the Project Plan, which is indicating 'Red' even after a Task is complete, with this formula. =IF([Schedule Delta (%)]@row > 0.1, "Red", IF([Schedule Delta (%)]@row > 0, "Yellow", "Green")) Could I use a formula to ask it only to count if "Status" is…
-
Office Clinic Patient Registration Booking
I am looking to set up a booking system for a downtime project to be able to use in our offices (clinics). I would like to be able to see the rooms for that location and the availability for each time slot. Ultimately if a patient checks in they would then be assigned to a room during registration. 2. Is there any…
-
Formula result can't be copied and pasted correctly
I am using a formula that takes the value from several columns to generate a job name and number. It works beautifully but for some reason, it's putting a space after each "_" and so I have to use "wrap text" to display appropriately. However, we used to be able to copy the job name generated and paste into another…
-
SUMIFS statement not working as intended.
I have a SUMIFS statement that I am trying to calculate a total of $ if it meets two criteria from another sheet. I am looking for it to meet the criteria of RRC Status: Engaged and RRC Pathway: Essenitals. The formula appears to be configured correctly from what I can see but returns it as #UNPARSEABLE. Is there something…
-
Freeze current value of cell with underlying formula
It would be great to have the ability to freeze the current value of a cell which has an underlying cell or column formula. Ideally this could be done manually or through an automation. Also having the reverse ability to unfreeze, which would allow the underlying cell or column formula to be reapplied. Where this would…
-
Date Formula for the Monday following a Date
I'm looking for a formula or automation that calculates the date of the Monday following a specific date. The initial date may be a Tuesday, Wednesday, or Thursday, but the date I need to "fill in" will always be Monday, as it's a due date. In the example below, the Schedules Due Date column needs to be the Monday after…
-
Nesting DISTINCT into an AVERAGEIF formula
Is it possible to use the DISTINCT function within the AVERAGEIF function? I need to average the number of days a PO has been on order if a specific purchase group number was used to create the order. The problem is that our data is pulled from SAP, which displays the POs line by line, meaning that there are multiple rows…
-
How would I write a formula to locate duplicates in 1 column and the difference in another column.
I have 1 sheet that has duplicated Classroom IDs but different scores on each line. I need to flag any instances during the same term of a difference over 1.00 higher or lower with the same Classroom ID. I need to find the repeat instances within column "Classroom ID" that occur during the same Column "Term Name" and then…
-
How to use COUNTIF on a Smartsheet Report
Hello - I have a report that manages all past due, in progress, and upcoming tasks sorted by team member. I am trying to use the COUNTIF formula on my Metric Sheet to count the number of past due tasks by team member in the report. My goal is to use my Metric Sheet to gather the number of past due tasks by team member and…
-
moving Just a Column to a new sheet with Automation
is there a Way that i can Move just a Column in a Sheet to another Sheet that will just Grab the Column. i would like it to work like the Automation that it Grabs the Row any time something is Triggered. but i would like it to just Move the 1 Cell from a Column not the Row as i don't need anything else just what got…