-
Strip Time When Linking Max Modified (Date) Cell to Column with Restrict to Dates
Hi Smart Sheet Community! I am applying a formula to a cell in our project schedule sheets thatย I found in a couple posts to grab the MAX value of the Modified (Date) column: =MAX(Modified:Modified) + "" My colleagues and I will be linking the cell with this formula from our project schedule sheetsย to a "Last Updated"โฆ
-
Ignore negative: Calculate time between dates ignore negative numbers
I am running a formula to calculate the days between a start date and today(), if the number is less than 25 then it inserts today's date in a cell. That cell is then used to trigger an email to a user for action. If the start date is in the past the calculated days between is a negative. I want the formula to ignore theโฆ
-
SCC Nesting Summary Data
Is it going to cause any issues if I nest (indent a couple levels) data inside a sub-category, inside of a main category? (see attached img)
-
Need Formula to auto populate todays date when box checked
Please share the formula that will auto populate the current date or "Todays Date" in the Completion Date column when the checkbox is populated in the "Done" field.
-
How do Link a Column w/ drop down items between separate forms/sheets?
I'm new to SS. This is my first project. I have an audit process I am building for a customer. There are 5 separate forms needed for the audit process. I originally had all 5 forms feeding the same sheet but with over 100+ columns for each audit, I went crazy scrolling left to right looking for the information I needed andโฆ
-
Dynamic Status
A more refined and slightly more universalย solution to the first postingย is as follows: =IF([% Complete]18 = 0, "NOT STARTED", IF(AND([% Complete]18 > 0, [% Complete]18 < 1), " IN PROGRESS", IF([% Complete]18 = 1, "COMPLETE", IF([% Complete]18 > 1, "INVALID ENTRY", IF([% Complete]18 < 0, "INVALID ENTRY"))))) This assumesโฆ
-
JOIN, COLLECT with MATCH
In Sheet 2, I want to JOIN and COLLECT a group of values from Sheet 1, separated by a comma. I have this figured out: =JOIN(COLLECT({AutomatedCourseCopy-CRN}, {AutomatedCourseCopy-CRN}, <>"", {AutomatedCourseCopy-UseinBCC}, <>"", {AutomatedCourseCopy-College}, CRN1), ", ") + "," I have a set of values in Sheet 3 thatโฆ
-
IF Statement Help
Hello, everyone - I'd really appreciate some help writing a conditional formula for a field entitled "Aging Type". There are 4 valid values for the field - Waiting on Approval Waiting on RFx Waiting on PO Waiting on Payment Waiting on COP The values are based on seven columns - ECM/IM Approved RFx # RFx Sub'd PO # COPโฆ
-
Lookup text or number in last cell
Hello, I know how to do it on Excel, but cant seem to get it to work on Smartsheet. I have sheet that gets updated by a form filled out by other people. I would like a formula that would get the last piece of information added to particular cells in this sheet (add to bottom row) and display this in an overview cell.โฆ
-
Formula to return the logged in user
Hello, Is there any formula to post(return) the name of the logged in user? I am trying to record the user name of the person who checked a box. for example, If I want to post a date when a box was checked, I write:ย =IF(Closed1 = 1, TODAY(), "")can we have something likeย =IF(Closed1 = 1, Logged user, "") I know that thereโฆ