Welcome to the New Smartsheet Online Community
You’ll notice that things have changed a bit. If you need help getting oriented, please take a look at the posts here in the Welcome to the Community category.
Recent Discussions
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
-
Welcome to the Smartsheet Online Community!AnnouncementAnnouncement Genevieve P. 507 views 21 comments 1 point Most recent by Andrée Starå Welcome to the CommunityFirst post 12/11/19,Last post 01/16/20Welcome to the Smartsheet Online Community! Here in the Community, you can interact with other Smartsheet customers to get help and share best practices. All posts and comments are monitored by Smartsheet employees, our moderators, to e…Welcome to the Community50721Genevieve P. -
First post 01/23/20,Last post 01/23/20Hi, -We get the above error message periodically while doing audits via an electronic tablet periodically when we select the submit button -Other audits are submitted without difficulty. (wifi is connected) -No difficulty doing that spe…Using Smartsheet101Lynn Collier -
Automation DisabledAnsweredFirst post 01/23/20,Last post 01/23/20Good afternoo, One of my automation tasks has been disabled and I cannot figue out why, can you please help? https://us.v-cdn.net/6031209/uploads/815/577N57QZN7TQ.jpgUsing Smartsheet91BESP10 -
First post 01/23/20,Last post 01/23/20Hi I'm on the Individual Plan 10 sheets max. The Business Plan with all its essential advantages is 300 sheets. I don't need 300 sheets and I believe I shall never need that many sheets in the next 20 years. Currently I'm packing differen…Using Smartsheet101director62476 -
First post 01/23/20,Last post 01/23/20Hello, Essentially what I am looking to accomplish is creating a workflow between a manager and his team around assigning files via a Master Template and the rows within the Master File being copied to each employees unique Individual Temp…Using Smartsheet40Shane Goodhew
-
Announcement Genevieve P. 128 views 1 comment 0 points Most recent by Charles Woerner Welcome to the CommunityFirst post 12/11/19,Last post 01/23/20Be respectful: Comments, discussions, links, or pictures that degrade any race, religion, gender, age, orientation, or abilities are not acceptable. Don’t spam: Advertising or promoting your company, website, product, or service is prohib…Welcome to the Community1281Genevieve P.
-
Answered Daniel Gomez 11 views 2 comments 0 points Most recent by Daniel Gomez Formulas and FunctionsFirst post 01/22/20,Last post 01/23/20Hello, I am trying to count the amount of times a particular "ticket category" is selected. Some of our tickets have multiple values to be applied and I am noticing that my formula does not count an item if there was more than …Formulas and Functions112Daniel Gomez
-
Text change based on value of numberAccepted AnswerAccepted Answer Kelly Buse 12 views 4 comments 0 points Most recent by Andrée Starå Using SmartsheetFirst post 01/22/20,Last post 01/23/20Hi All, I was hoping to create a formula that changes the text of a cell based on the number in another cell. Here is what I'm trying to make the cell display at each value range: Value is under or equal to 20 - Cell to display "N/A…Using Smartsheet124Kelly Buse
-
Question Edgar Alvarado García 7 views 0 comments 0 points Started by Edgar Alvarado García Formulas and FunctionsFirst post 01/23/20,Last post 01/23/20Hi there, In a sheet I've few cells that have formulas, columns were those cells are aren't lock, however the users cannot overwrite the formulas, any idea why it may happen? The idea was to create formulas as a guidance but editors shoul…Formulas and Functions70Edgar Alvarado García
-
First post 01/23/20,Last post 01/23/20Hello, I need a formula that can help me calculate the sum within a column based on date. Not sure if this can be achieved. We are updating information on a weekly basis and I have different rows for the same date. I need a formula to give…Formulas and Functions103Jona Gjylameti
-
averageif with multiple criteriaAccepted AnswerAccepted Answer taylor.thompson89836 13 views 2 comments 0 points Most recent by taylor.thompson89836 Formulas and FunctionsFirst post 01/23/20,Last post 01/23/20I am trying to find the average of time in position (demographics range 1)when the job class (demographics range 3) is manager or higher. I'm currently using =avg(collect to try to specify the multiple criteria but am getting a #divide by …Formulas and Functions132taylor.thompson89836
-
First post 01/23/20,Last post 01/23/20Help! I cannot figure out a formula for SUMIF or SUMIFS to add a range of numbers in a column that are greater than 25,000 based on a checkbox. =SUMIFS({Content Limit - NB}, >25000, {Reporting - NB}, 1) <-- why doesn't this work. heh…Formulas and Functions30@Diana -
Combining formulasAccepted AnswerFirst post 01/23/20,Last post 01/23/20Hi, I need some help with a formula. I have a one check mark column that I would like to 'check' if any of the following formulas are true. Can I combine them into one large formula? =IF(AND([Key Activity]@row, 1, [CEC Tech]@row, 1), 1) …Formulas and Functions102Tina
-
Adding Help to a FormAnsweredFirst post 01/23/20,Last post 01/23/20Hi Everyone, I've written a Help guide for Smartsheet Form and I'd like to attach it the Form. I'm not finding way do this. Seeking help.. SidUsing Smartsheet141Sid Richardson
-
Formula in % Allocation Column?UnansweredFirst post 01/23/20,Last post 01/23/20I am certain this has been asked either currently or in the past, but is the capability to include a formula in the % Allocation column on the product roadmap? Right now, I have a column entitled "% Alloc Calc" next to the "…Formulas and Functions40Guy Behanna -
First post 01/17/20,Last post 01/23/20=IF(Status6 = "Open", IF([Due Date]6 <= TODAY(2), 1, 0), (IF([Send to High Risk Report Now]6 = 1, 1, 0))) https://us.v-cdn.net/6031209/uploads/777/529C59A6UPMV.png I have this formula that each IF function works on its own, b…Formulas and Functions285Angela Ryer
-
Pt 2: User and what they can seeUnansweredFirst post 01/23/20,Last post 01/23/20I have a specific dashboard that I would like to share with a colleague. I would like to give him the "editor-cannot share" permission, but when I select that, I can longer share the dashboard. I want him to be able to see just t…Using Smartsheet170cpezz
-
Using Emojis in SmartsheetsUnansweredFirst post 01/23/20,Last post 01/23/20We want to use icons that relate to our work. I have an IF formula that includes emojis. =IF(Classification4 = "BAGS", "🎒", IF(Classification4 = "SOCKS", "🧦", IF(Classification4 = "GLOVES"…Formulas and Functions70mel.greenspan -
First post 01/23/20,Last post 01/23/20The actual task sheet that contains that data has the text wrapped but for some reason it's not carrying over that way - I have tried to remove and re-add the column with no luck, all the other columns are fineUsing Smartsheet50Lori Jordan
-
First post 08/28/19,Last post 01/23/20Sheet 1: Work Scheduled (number of work units scheduled in a given month) Sheet 2: Budgeted Cost of Work Scheduled (to determine the total cost of the work scheduled in a given month) I would like to multiply a cell from Sheet 2 with the…Formulas and Functions24116JoeS
-
Automatic ticket numbering by locationAccepted AnswerAccepted Answer M. David 28 views 11 comments 0 points Most recent by Paul Newcome Formulas and FunctionsFirst post 01/22/20,Last post 01/23/20Hello. I worked with someone on a previous discussion, but for some reason cannot locate it now. I have one data base file with the work orders from many different community locations. I wanted a solution for the Work Order Number to be a …Formulas and Functions2811M. David
-
First post 01/23/20,Last post 01/23/20I am attempting to share a workspace with roughly 55 people in and outside our corporation. I crafted the instruction/invitation message shared the workspace. Those who HAVE SS, got a notification in the app pane. Those who don't got nothi…Using Smartsheet80bkw1962
-
First post 01/23/20,Last post 01/23/20Hi! I have created a Row Report containing information from just one sheet, with one "What?" criteria. I have the desire to add another column to this report, that does not come from the original sheet, just for notes purposes. T…Using Smartsheet70Casey Sabatini
-
First post 01/23/20,Last post 01/23/20Hello, My users have been asking me to unhide the same columns over and over all day. I'm the owner/administrator. They are unlicensed editors. I unhide "columns x y and z" and save. A moment later I see a notice "User 1&qu…Using Smartsheet90johncory -
First post 01/23/20,Last post 01/23/20Hello, I found this link in the forums (https://community.smartsheet.com/discussion/59066/baseline-a-project-schedule) but It didn´t really answer my question. I want to create a project baseline that can track and compare the baselin…Using Smartsheet70Eugenio Noriega
-
Answered Sean Taber 153 views 18 comments 0 points Most recent by Genevieve P. Formulas and FunctionsFirst post 06/18/18,Last post 01/23/20Hello, I'm trying to calculate the average number of days but only for columns that meet the criteria. I have a formula that is calculating the networkdays between two dates. This column is called Implementation Time (Days) - BD. I am no…Formulas and Functions15318Sean Taber
-
First post 01/23/20,Last post 01/23/20I am wondering if anyone can help point me in the right direction in setting up this smartsheet. We are trying to automate an email notification for over 100 employees for when they receive a time accrued balance at the end of the month. I…Using Smartsheet110Clyshaw Whipple
-
First post 01/23/20,Last post 01/23/20Anyone got any clever workarounds to set the width of a column object to the width value of the widest cell in the column content-wise?API & Developers70StephenG -
Need assistance with a formulaAnsweredAnswered Nikhil Chawla 14 views 1 comment 0 points Most recent by [email protected] Formulas and FunctionsFirst post 01/23/20,Last post 01/23/20Hello, I am using the below formula to count the number of rows where 140R was checked previous month. This formula was working perfectly fine until this month when the year changed. How can I fix this formula where previous month should b…Formulas and Functions141Nikhil Chawla
-
Formula to average a range in another sheet corresponding to cells that contain parts of textAccepted AnswerAccepted Answer lhumphrey 9 views 3 comments 0 points Most recent by [email protected] Formulas and FunctionsFirst post 01/23/20,Last post 01/23/20I can't seem to beat this formula. I've tried COUNTIF, COLLECT, CONTAINS, and when I'm not getting an error I'm getting 0. I want to see the average of successful deliveries below for all Up to Date emails in Q1. In the sheet I'm working w…Formulas and Functions93lhumphrey
-
First post 01/22/20,Last post 01/23/20Hello, Looking for formula help. I have a master Smartsheet with email addresses and a second Smartsheet with a form that will populate with email addresses entered by the user, so they may not be entered 100% correctly (fuzzy lookup?). I…Formulas and Functions161Dedrick Tai
