-
Index/Match, I *think*
Hi! I'm (I think) trying to make an index/match happen. I'd like Smartsheet to look for a matching contact in another row, and then copy three cell values from the lower row to the higher row automatically. Is there any way to do this? Alternatively, I could live with doing this for every column that needs it. So for…
-
Formula Help: Find Value in 1st Row in Same Column, without using Absolute References
I'm trying to create a formula that gives me the value of the first row in the same column. [Find This Value]. There are a few obstacles: The formula is placed in the same column, BELOW value we're trying to find, in [Find This Value]13:[Find This Value]21. So it needs to be a cell formula and not a column formula And my…
-
Date & Timestamp a specific cell change
Hello, I am very new to Smartsheet and I am working on a project tracking sheet. We have the following statuses in a cell: Unassigned; In Progress; Completed; Cancelled; On Hold When a request is submitted this automatically triggers a 'Created Date' column that logs the date/time of creation. I would like this to be…
-
Data Shuttle Issue
I have set up a data shuttle that should run when an attachment is added. On the same sheet, there is an automation that automatically moves rows to another sheet when they are filled out. Currently, every time a new row is added and moved to another sheet, the data shuttle runs and adds data to the sheet, even though the…
-
Formula Help
Hello I am looking for assistance with a formula. What I need is '# of days for COC Completion' to equal 'Date COC was Finalized' - 'Date COC Determined' with a cavoite that if 'Was PCT hospitalized within 14 days of COC' = Yes, than instead of 'Date COC Determine' it needs to go off 'Date D/C from Hospital' Is that…
-
INDEX/MATCH showing #NOMATCH
I have 2 sheets: Source Sheet: KI Tasks Report Target Sheet: MLE Access Management All three columns in each sheet are text Formula in MLE Access ProjCode column: =INDEX({CE+RxE From KI_ProjectCode}, MATCH(ClientID@row, {CE+RxE From KI_ClientID}, 0)) Formula in Project Manager String column: =INDEX({CE+RxE From KI_PMName},…
-
Pause "Days in Progress" counter
Within our SS solution we have a formula that starts a day counter from project status of "assigned" and stops counting when the project status is marked "complete". So if a project was assigned on the 5th day of a month and the project is marked complete on the 10th, it captures that the project was worked on for 5 days.…
-
Formula Issue
I'm trying to write a formula that will turn a date format of MM/DD/YY into Mon-YY (for example, 02/19/25 into Feb-25, or if the date cell is blank, then I just want a blank returned. Here's what I have : =IF(MONTH([CLEAR Approval Date]@row) = 1, "Jan-" + RIGHT(YEAR([CLEAR Approval Date]@row), 2), IF(MONTH([CLEAR Approval…
-
MAX and INDEX
I need help with a formula. I am trying to create an index formula to get back a specific column data but i want to get the latest one. This is my sheet im referencing. the first column (Plan of Care Cognito ROw ID) is my auto numbering column. On my original sheet im creating the formula on, i have a "HHAX Admission ID"…
-
Help!! :) IF, IF(AND(, IFERROR(INDEX,MACTH(
Trying to figure out the formula. I'm looking for 3 conditions here IF cell is "0" true insert "-" IF cell is "-" true insert "-" IF(AND cell is > "0" AND cell = "-" true insert "-" IFERROR(IDEX(MATCH Here is the formula: =IF([# Phones]@row = 0, "-", IF([# Phones]@row = "-", "-", IF(AND([# Tablets]@row > 0, [Phone MDM…
