Join the Smartsheet Community
Find answers to Smartsheet questions, learn about project management best practices, discuss the future of work management, and get how-to guidance for every Smartsheet use-case from fellow users and Smartsheet experts.
Discussion List
-
Is there an easier way to automate multiple columns from a single multi-select dropdown?In Formulas and FunctionsOne of my teams uses a sheet to track to the status of products in every state, with a column containing a status dropdown list for each state (Requested, In Progress, On Hold, Completed, etc.). We recently implemented a form for our inter…Answered - Pending Review 22 views 3 comments 0 points Most recent by Paul Newcome Formulas and Functions
-
Duration v actual timeIn Formulas and FunctionsIs there a way to add a task that might be 4 days over a one month period, for example. So I don't have to create a separate task for every time that task happens, I just want to show a task that runs from 1 May to 30 May but takes 4 days …Answered - Pending Review 17 views 5 comments 0 points Most recent by Genevieve P. Formulas and Functions
-
Summary Report is not showing all data to all usersIn Using SmartsheetWe have create a summary report that links to our current projects and pulls specific information for each project's summary sheet. The report has one line for each project. Myself and the other user on the report below are both admin user…
-
Auto scheduling tasks/recurring tasks NOT WORKFLOW!In Formulas and FunctionsI can see "recurring tasks" has been asked for by the community for years, but I can't see it has ever been developed, I'm hoping it has and I just can't find it. I want to be able to automate the following: A bi-monthly task tha…Answered - Pending Review 33 views 3 comments 0 points Most recent by BeckyK5555555555555 Formulas and Functions
-
add a day to entire projectIn Using Smartsheetwith different due dates.. adding a day to one task will move all dates in project out... how to I do this withough manually having to enter each new date?
-
Using Index Collect formula when there are multiple matches in the source sheet. (#Invalid Value)In Formulas and FunctionsHello, My goal with using INDEX(COLLECT)) was to obtain information based on 3 different criteria, but in my source sheet there are multiple matches for the three criteria specified. What do I need to add to the Index, Collect formula to …
-
Maximum Cell LimitIn Using SmartsheetHello, I know the maximum number of cells in a sheet is 500,000 cells in any combination of columns/rows. We use a form to collect data from our field staff. Some columns are not mandatory except when certain responses are provided. So…
-
Date Format sometimes incorrectIn Formulas and FunctionsHi Firstly I am using English formatted dates DD/MM/YY (because the US format is wrong and terrible) I have a sheet with dates in it. I have another sheet that points to these dates. If my source dates are 33/12/2021 or similar they work …Answered - Pending Review 10 views 2 comments 0 points Most recent by Genevieve P. Formulas and Functions
-
Editing/Updating ContactList or Dropdown Items via the APIIn API & DevelopersHi guys. We are making good headway pushing data from our CRM to SS with the API with VB and C#. One of our sheets needs to have a column with a list of (regularly changing) people for the users to select from in a ContactList or Dropdown …
-
Data Drop Down ListIn Apps, Integrations, and Add OnsI use SS with my team as a time-tracking solution. I have each employee - 24 of them- (collaborators only) a form they fill out for each job they work at. Each employee has to have their own individual form because I also collect other i…Answered - Pending Review 31 views 4 comments 0 points Most recent by Zippo Apps, Integrations, and Add Ons