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
Yay! Text formatting in Smartsheet formsIn Using SmartsheetSmartsheet forms now have the ability to format text in the form title, form description, and field help text. Check it out and let us know what you think. Style (Bold, Italic, Underline) Text color & highlight color Bullets & num… -
Insert image to cell in batchIn Using SmartsheetBefore I write some code, I am checking if this functionality exists. I have 400 images that will be uploaded to a Smartsheet in a batch mode. These are to be inserted into a cell in a column, not uploaded/attached to rows or the sheet. I …
-
Hi AllIn Formulas and FunctionsI am trying to do a COUNTIFS formula in the summary field. II can get it to work with COUNTIF, however COUNTIFS returns an error (Unparseable). I am trying to get a count from two columns in the sheet to calculate in a summary field Colum…Answered - Pending Review 14 views 3 comments 0 points Most recent by Andrée Starå Formulas and Functions
-
COUNTIFS across multiple columnsIn Formulas and FunctionsHello! I'm trying to write a formula that tells me how many rows meet the criteria in multiple columns. It works with criteria in two columns, but when I try to incorporate a third, I get an incorrect argument set, or an invalid operatio…
-
Copy & paste shortcut vs. keyboardIn Using SmartsheetHas anyone else experienced this, and is there a reason why this happens? When I am trying to copy and paste, it works fine when I use ctrl+c and ctrl+v, but if I try to copy using the right click option, it appears nothing happens becaus…
-
How do you automate a status updates in smartsheet with IF formula?In Formulas and FunctionsMy organization would like to automate the statuses in a project plan. Could we create an IF formula to accommodate this logic? Examples: If the start date is in the past and the percentage is 0%, put status in yellow If the percentage is …
-
Automatically creating event recurrencesIn Using SmartsheetHi All - I am creating an event calendar (to be coupled with the Calendar App) and I would like to enable folks to submit a recurring event, noting the frequency as once a week, every 3rd Thursday, etc. I capture the initial start date, b…
-
Work Breakdown Structure (WBS) - Column Formula ConfigurationIn Best PracticeHello Everyone, Recently myself and two fellow Smartsheet Sales Engineers, @Lea Gikas and @Dave Stanley got together to create a WBS solution powered by Column Formulas. We wanted to provide the resulting configuration to the community in…
-
Date auto fill not working?In Formulas and FunctionsI am trying to fill 3 months of consecutive dates without manually typing them all in, but all I get is the same 2 dates repeated, instead of consecutive dates? I am typing in the first 2 dates, then dragging the corner down, but all it do…
-
The need for Forms to update an existing row and not send a requestIn Using SmartsheetI see the constant request to have Forms update an existing row and yet it hasn't come to fruition yet? I'm facing the same issue with the need to have users, in this case mechanics, update a Form to reflect anything they may have worked o…
-
IF with MAX(COLLECT issueIn Formulas and FunctionsHello! I am stumped by a problem I'm working on. Part of my work is to assemble a dashboard that shows the maximum number of occupied beds at several homeless shelters in a given period of time during the previous night. Supervisors at eac…
