-
Cumulative Column Formula with Exclusion
I have a cumulative column formula created that cumulatively adds up months, if we're in May, it will add Jan-April, if we're in June, it will add Jan-May, etc. There are some metrics the customer wants to be excluded from this formula and instead, have the formula provide the last month entered. I created a checkbox…
-
Change status if progress bar changes (help w/syntax)
Hello I want the status to change if the progress bar is changed. I tried a formula but only have it half working. =IF(AND(Progress1 > "Empty", Progress1 < "Full"), "In Progress", IF(Progress1 = "Full", "COMPLETED!") This is the formula. I want the status to show either 'Not Started' , 'In Progress', or COMPLETED! based on…
-
Flagging a double booked room
Hi Guys I have a tracker that my team use to manage their daily tasks. However, due to COVID there can only be a specified number of people in a room at a certain time. Often rooms have been double booked, resulting in work being delayed. I want to highlight whether a room has been double booked on a specified date by an…
-
What formulas to use in a timesheet solution to SUM up values
Hello, I have used one of the great solutions that has been posted by, I believe, @Paul Newcome relating to tracking and working out time/duration of hours in a HH:MM format. There are 2 columns to achieve this - the first uses a formula to work out the numerical duration: =((VALUE(LEFT([End Time]@row, FIND(":", [End…
-
My SUMIF formula stopped working and I don't know what's wrong!
So I have this formula and it was working fine, but I updated the sheet with new people - new names in the intern field and so changed the formula to align with the new names. Now it's showing as an Operational error, but I have no idea what's wrong - anybody have an idea??
-
How to set up move row automation with formulas
I currently have a formula in place to "star" a row on sheet A when a unique identifier # from sheet A is added to sheet B. Then, I would like to move the row from sheet A to sheet C after the "star" is highlighted. I read the statement below in the smartsheet Automation article: "Actions that will automatically modify the…
-
Changing Primary Columns
I have a number of smart sheets that all 'talk' to each other, and feed various dashboards and reports. Slight problem in that the primary columns across them all are different - partly an oversight when setting them up, partly due to different people in the organisation setting up different sheets which I have since…
-
At Risk Flag
Hello, Based on example from sheet provided, I'm looking for formula to populate in the At Risk column to flag as At Risk if Final Due Date is seven days out and the Status does not equal "Yes" and % Complete is not 100% Any support is appreciated!
-
Between Dates Formula Referencing Another Sheet
I have two sheets I am trying to tie together. Here is the scenario: Sheet 1 (Below): Has the city reference. Current Rent is where I am trying to type the formula. Idea is to return the current rent based on today's date and the city. Sheet 2 (Below): Has the rent schedule range and the city to reference. There will be…
-
How to add a value from any row that has column = May
This sheet (displayed to users as cards) moves projects to different months for capacity planning. We then have a header task for each month which we display the total job value currently assigned to the month. This value is currently manually calculated. How/can we have a formula in the header task that sums all the $…