Recent Discussions
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
-
Announcement
New! Clear cell automated action + change cell enhancementIn Product AnnouncementsHi Community, I’m the product manager for automated workflows at Smartsheet and am pleased to share two announcements with you. First, you can now use a workflow to automatically delete the contents of a cell whenever the conditions you’ve… -
Announcement
What would you like to see us doing more of in the Community?In General AnnouncementsWhat can we do to help make the Community more valuable for you? We want to hear from YOU! Of the following options which would you most like to see us doing more of? If you have other suggestions you would like to share, please feel free… -
Join Collect DistinctIn Formulas and FunctionsSmartsheet Community: Not Sure what I am doing Wrong but I am trying to Collect Data in another Sheet only Once. Therefore if it appears twice in that Sheet in that Colum, it should only Collect it Once. Current Formula: =JOIN(DISTINCT(COL…
-
Is there a limit to adding VLOOKUPs?In Formulas and FunctionsI am working to sum multiple columns that match a specific criteria. I was able to accomplish this with the SUM formula and using VLOOKUP. It works when I add 2 VLOOKUP formulas together but if I add more, it says #NO MATCH. Is there a lim…Answered - Pending Review 9 views 2 comments 0 points Most recent by Kelly Pratt Formulas and Functions
-
Can this formula be fixed to get the correct time?In Formulas and FunctionsHello, I am trying to come up with a formula to track time in Smartsheet. This is the formula I have: =IF([End Time]@row < [Start Time]@row, ((1200 + [End Time]@row) - [Start Time]@row) * 0.01, (([End Time]@row - [Start Time]@row) * 0.0…
-
IF is Integer?In Formulas and FunctionsI have a formula column that is constantly changing and bringing in live information. If the numbers are integers, I want to see them rounded with no decimal point. If the numbers do have decimals, I want to see only 1 decimal place. Press…
-
Grouping dates in reports not working as expectedIn Formulas and FunctionsWe have started using the grouping function within several reports and grouping on a date field but we are coming across tasks with the same dates not appearing within the same grouping? We are not grouping by any other column and the for…Answered - Pending Review 73 views 15 comments 0 points Most recent by Vicky Athersmith Formulas and Functions
-
Can I change the order of my secondary grouping in the Calendar App?In Apps, Integrations, and Add OnsHi, I'm having an issue getting the order of my groupings for my secondary column to appear on the Calendar App in the proper order. I am using a multi-select column from my main sheet. I understand I can not dissect the individual select…
-
Date Visibility Logic CheckIn Formulas and FunctionsI have 3 dates (Calc, Planned and Actual). I want a logical function to check and pick the most accurate during the project lifecycle. It starts with a Calculated date and then Planned is updated as the proposals come in. As the vendor …
-
Checkmark Column FormulaIn Formulas and FunctionsAfternoon, I have tried every formula in the book to count all check marked boxes within a column. Can anyone just write the formula that works for them? This is the formula I am trying to make work- =COUNTIFS([Construction Complete- No…Answered - Pending Review 11 views 6 comments 0 points Most recent by Andrée Starå Formulas and Functions
-
Formula for LightsIn Formulas and FunctionsHi all, I have a sheet that contains fields for "Preparer Due Date" and "Preparer Status" and am trying to add in the following logic to a formula: Blue = completed Green = task not started or in process that are due …
-
Converting from Trial to License userIn Using SmartsheetBest practice in adding new person onto Smartsheets. We have an open license, but the new user is currently using the free trial. How do prevent any loss in data & ensure easy transition?
