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
-
Creating a Lookup SheetIn Using SmartsheetHello My Fellow Smartsheet Gurus, Today I am in need of some advice. I have a rather larger sheet used to track requests. I have a separate sheet that allows user to type in the a lookup ID and it pulls all the relevant information into …
-
Countifs OR Formula IssuesIn Formulas and FunctionsI am doing a countifs formula, and am unsure how to include an OR formula. In the Summary Program column located on another sheet, I want it to count the number of both Bi-Annual and EMEA cells. for rows which Summary Season is S21 This i…
-
Can character limits be added to Text fields?In Formulas and FunctionsI have a free text comments field in a sheet, but I want to limit the number of characters people can enter into it. This is to try to keep comments brief and to the point. Is it possible? Thanks
-
Find the unique dates from a sheet AND display them from oldest dateIn Formulas and FunctionsFrom a previous post I can find all of the unique dates from a sheet within the last 45 days. My problem is that the dates are not listed from oldest to newest, so when I add this information to a dashboard it does not display correctly. H…
-
Is there a way to prevent cell value assigned by formula from changing after sorting?In Formulas and FunctionsWe need to assign a number and letter combination in each row of a sheet. Some rows are considered to be "in a series" and will need the same number but a different letter, i.e. 40001A, 40001B, and 40001C. We have a formula that…
-
Countifs and Is not blankIn Formulas and FunctionsI am trying to create a formula where it counts the number of rows when an invoice has not been approved. This is what I have and instead of changing the name for each person, I want to create one where it counts when the Approver column i…
-
Forms and Automation with Contact Type CellIn Using SmartsheetI want to have clients submit a form which includes their name and contact information, and then set recurring update requests to be sent to their emails. I tried to accomplish this by creating two different (Text type) fields on the form,…
-
Does Smartsheet provides non-English language support ? for example - Japanese clientsIn Using SmartsheetHI , I've got a request from a user , he's wondering if Smartsheet can provide support to NON- English language users. If yes then how ? if the answer is NO , then how can I help non English speaking users. Appreciate the help
-
Creating Color Coded ColumnIn Formulas and FunctionsHelp me out here guys... I am trying to create a color coded formula that would produce the following results: If date file received is not blank – populate green. If date file received column is blank AND….. If today’s date is 1 day olde…
-
if the answer is zeroIn Formulas and FunctionsWhats the correct way to do this? =if(SUMIFS({Service Projects Tracking Master Log Range 1}, {Service Projects Tracking Master Log Range 2}, AND(@cell >= DATE(2021, 8, 1), @cell <= DATE(2021, 8, 30)),0,75,000)Answered - Pending Review 14 views 2 comments 0 points Most recent by Genevieve P Formulas and Functions
