-
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…
-
Formulas for using the symbols
Hello - I love the new symbol options for the columns. I'd like to use use the up / down arrows to help me track some $$ to budget info. I have been trying to figure out which formula to use via the templates and I can't sort out how to do it. I know I can use conditional formatting to accomplish something similar, but I'd…
-
No notifications in Board view?
Morning all (8am in NZ!) Just getting to know Smartsheet, but one thing is killing me at the moment and its i cant seem to get ANY notifications working. Im running a workflow system using the BOARD view, but have also tried switching to list view and still nothing. No matter what i set up under Alerts and Actions NOTHING…
-
Calendar - How Do I Add Times for start and end of meetings, etc.
I'm new to SS and cannot yet figure out why the calendar doesn't allow me to display start and end times for meetings, etc. Is this possible? If so, where is this done? All I see is date related not time. Thank you!!!
-
Formula help predecessor
I need a formula for If there is a predecessor the status of predecessor is complete (other row) than show "start" If there is NO predecessor show "start" How can I make this? Name of columns: Predecessor: Voorafgaande taak Status: Voltooid THANKS!