-
Error Code 4002 - Server timeout exceeded. Request has failed.
Does anyone have experience dealing with Error Code 4002 (Server timeout exceeded. Request has failed.), and has any ideas on how to handle it. It seems to come up for me when i am trying to update larger sheets Thank you
-
The order in the form does not match with the order in the sheet
Hi group, I created a survey in Smartsheet and I see that the order of questions in the form does not match with the order of columns in the sheet. This may be because some questions were added later into the form and inserted between existing questions. The order in the form is the correct one. Do you know how to easily…
-
Project Management
We have 4 employees that receive daily projects assigned to them. To avoid having the employees viewing their co-workers daily schedule by sharing the project management sheet and doing a filter so they only view their daily projects but can also turn off the filter as they please to see the complete project management…
-
Smartsheet Formula for Multiselect cell based on time
Hi, I have created a form for our clinical therapists to enter type of service or referral provided for particular clients each week. I want an automation that takes this data and lists services provided to a particular client on another sheet if it was completed in the past week. The formula I've been working with is:…
-
How can I change the Card View to show a different column?
Currently my Card View is showing my "Status" column and I would like to change it to the "Assigned to" column.
-
Can I conditionally format a cell if it contains text from a range consisting of multiple rows?
I have a column containing text (multiselect drop down) that I would like to eventually conditionally format based on the presence of matching text from cells in a range made of multiple rows. Here is fictitious data in an excel format for simplicity. Sheet 1 Range 1 (Column C) contains the data I want to format based on…
-
Merged: My charts randomly errored out, but I haven't touched the metrics that feed them
This discussion has been merged.
-
Hi, what is the best formula to collect a text in a range of column and return it into main column?
-
Change calendar (column type: date) to years (not months)
Hi all, Just a quick question - when using the column type 'date' in a sheet, is it possible to make the calendar which comes up for selecting the date in question a 'year' calendar rather than a 'month' calendar? Many people using the sheet/form will be inputting dates from about 50 years ago, so a calendar by month…
-
Multi-Step Workflow: Creating and Linking Forms with Unique Identifiers
Good morning! I'm trying the following in Smartsheet: 1. Create a form that has a field to input multiple emails, each submission has a Unique ID. 2. When the form gets submitted, it will send an email to the emails in the submition with a new form of a different sheet. 3. Once the second form is filled by the email…