- How can I update a date cell to change to the following year automatically?
Hi, Hoping someone can assist. I have a sheet with automations built in. Basically, a form is sent out on each respective date and then the QTR column updates to the next QTR. So Q2 date reached, form sent and QTR column updates to Q3. What I want to know - Is there any way I can then have my Q2 date updated to 01/07/24?…
- How can I index/match the latest information from my source sheet when 'match' data duplicates?
Hi, Hopefully this make sense :) I have two sheets. A source sheet and a master sheet. I would like the master sheet to pull the start date from the source sheet when it matches the client number. This works fine when I use INDEX MATCH if there is just one client number. My issue is that the source sheet will contain a…
- Can IF and the JOIN(COLLECT) formula be used together?
Hello, I have a sheet with data. The data is populated from 4 forms and therefore populates in rows. The data needs to then be collated on one Smartsheet, and I am looking to pull through all the quarters into one cell where the quarter is "Q1". I have successfully pulled through all the "Q1" to show in a cell, by using…
- 为什么我不能更新列细胞在一个update request if it already contains content?
Hi, I have a cell which has a target date in it and I need individuals to update the target date if it will not be met, but on my update request email (sent via automation) I am unable to update the target date. Why is this? Thank you,
- How can I update cell 1 with the information from cell 2 when cell 3 is "1"?
Hi, I want the selected cell in Column19 to pull through A, B, C, D, E or F if the search filed has a "1" in it. I have tried INDEX MATCH, nested IFS, but nothing seems to work. Closest I got was a 'No Match', but not sure why the corresponding letter was not pulling through. This is all on the same sheet with columns…
- Can you present the questions from an original form on an update request?
Hi, I have a form which looks great, but when I request an update it takes only the column names in the notification to the user. This then means my update request questions are not clear. Example: Form is 'Have you completed all the risk checks'. The related column on the sheet will only have 'Risk Check' with options…
- Can the answers on a form link to a pre-populated row/column?
I have a sheet with pre-populated client names. I have columns with questions that then need to be answered and I have two forms. I am able to send the forms for completion on the due date, but when they are submitted the details fall to the bottom of my sheet and does not align to the relevant client. I don't want to use…
- Is there an way to split a multiple value select column into separate columns?
Example: I have a column with multiple select value for 5 services (S1, S2, S3, S4, S5). I would like to split this quickly or be able to show the separate services on a report, but the report function does not seem to be possible. I have looked at the substitute formula, but the work involved to separate it this way is…
- Merged: Copy/Move function
This discussion has been merged.
