- INSANITY or EMPLOYEE EGO or MANAGEMENT INATTENTION??
I have seen some of these head-in-the-clouds people at Microsoft do some really stupid "improvements" but this tab thing takes the cake. I am a shareholder in this company and am considering selling due to management's inattention to their business. Good management would never let a thing like this happen.
- Find and Replace to edit references
Hi! I am trying to edit the three cross-sheet references in all the columns from the master sheet of 2018 to master sheet of 2019. Since I need to repeat it for almost 1200 cells. Is there a way to bulk edit like Find and Replace or something else? Even for selected cells will make it so much easier! the original is :…
- SUMIF with two Ranges.??
I want to create a cross-sheet formula and have two conditions for the formula to go through to result in a value. If the value in column1 is 1 and column2 is VendorX then sum all values in column3 corresponding to the conditions. I am not sure if the SUMIF will work for this.
- Dashboard Color
让我们的未来计划update the dashboard background color to any color we'd like? I'd love to be able to use black for dashboard backgrounds, as well as the backgrounds of the widgets, so that when on TV sets around the office, graphs are floating in black instead of a white background.
- Adding virtual sticky notes
I have a sheet detailing meetings with dates, times and locations lined out. What is the easiest way to add a note to the overall sheet that shares info that applies to all events? I want to essentailly add a sticky note to post my list of items to bring to each event. Any ideas how to do something like this?
- Is it possible to create a web form with appointment time bookings?
Hello, We're looking to run an event where people can meet 1:1 with an onsite consultant but want people to book a time. Does SmartSheet allow the creation of a web form where people can select from a time slot and then it no longer become available for anyone else? Thanks, Julie
- COUNTIF Formula for when a cell contains a specific word/phrase?
I'm trying to create a formula that allows me to count the number of times the word "Postcard", for example, appears in a list in a column. I am referencing a column in another sheet to do so. However, nothing I've tried works. My instinct was to try =COUNTIF({2018 Open Enrollment Feedback Range 1}, "Postcard"). However,…
- Convert Form to PDF
Hi, I would like to be able to convert a completed Smartsheet form into a PDF document, either prior to submitting the form, or from the entry in the worksheet once the form has been submitted. Is there any functionality within Smartsheet that will allow me to do that? Thanks.
- Cross-Sheet Formulas
Hi! I am trying to reference another sheet in a SUMIF. But I get "#UNPARSEABLE" I want to sum contribution $ in Column 2 if the vendor name is 9X. This info is in Sheet2. I am referencing it in Sheet1 Here is the formula : =SUMIF({VEND},"=9X",[{DSU}]) I have tried the formula =SUMIF({VEND},"9X",[{DSU}]) And…
- Copying Alerts From Column on Sheet 1 to Column on Sheet 2
I've set up a set of three alerts triggered by a date in a column and it's quite lengthy (but works). I now want to eliminate rekeying it to 15 other sheets within the same workbook by copying the alerts and placing them in the remaining sheets. Is there a way to paste them into another sheet? Please let me know if anyone…
