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
-
Collaborators unable to edit after upgrade to proIn Using SmartsheetWe have recently changed our subscription to pro due to the growing number of sheets required. However since then my collaborators both free and paid users can no longer edit sheets owned by us. Permissions have been set to edit and even c…
-
Count number of times "Yes" shows within a date rangeIn Formulas and FunctionsHello, I am trying to get a count of how many times Yes appears within a date range - i.e. July = 2 x Yes, August = 1 x Yes. I have been trying with the COUNTIF function but haven't worked it out yet. I am trying to return the value on a s…Answered - Pending Review 14 views 2 comments 0 points Most recent by Genevieve P. Formulas and Functions
-
Combine individual Contact cells by formulaIn Formulas and FunctionsHi, I have 2 individual columns and they are with property "Contact". I would like to combine the contact values of these 2 columns and store them in the 3rd contact column, that means the 3rd column can store multiple contacts i…Answered - Pending Review 42 views 2 comments 0 points Most recent by Genevieve P. Formulas and Functions
-
Project Health formulaIn Formulas and FunctionsI want to create a formula that accomplishes the following: If [Target End Date] is today or later or if [Actual End Date] is on or before target end date = Green If [Target End Date] is 1-3 days ago and [Actual End Date] is blank or [Act…
-
Multiple contacts per cell not receiving automated update requestsIn Formulas and FunctionsI have an email contact list being populated by a Vlookup that is part of an automated workflow. I have "allow multiple contacts per cell" checked as part of the column parameters, but in every cell where there are two email addr…
-
Returning a date from another sheet using two criteriaIn Formulas and FunctionsI have two sheets, one being a Related sheet that has three columns: Number, Label, Date Then there is a Main Sheet that also has Number, Label, Date (plus other columns) This is simulating a One-to-Many relationship as the Related Sheet c…
-
I need to SUM points based on user and then sort by aggregated pointsIn Formulas and FunctionsI have a sheet similar to the one below: I need a way to display my results like this: I can create a report but it won't sort it based on the aggregate function. Any help would be much appreciated.
-
Sheet Summary Report Builder only shows the system columnsIn Using SmartsheetI am trying to create an aggregated view of data from multiple sheets using the "Sheet Summary Report" but when get to the Builder, it only shows the system columns for display. Obviously this is not helpful if I cannot merge tog…
-
Wrap text for header possible?In Using SmartsheetHi there, is it possible to wrap a text in a smartsheet header? Thank you & best regards, Manuel
-
Does anyone know if its possibly to use INDEX MATCH to pull in images?In Formulas and FunctionsThe formula seems to be working but it pulls in the PNG name and not the image. although the image name doesn't match. I am not sure what is going wrong. it looks like it is pulling in the name of the last icon image. Does anyone have any …Answered - Pending Review 11 views 1 comment 0 points Most recent by Andrée Starå Formulas and Functions
