-
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…
-
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!
-
Sheet Name Appearing within Google Calendar Milestones
I understand that when publishing to Google Calendar the Smartsheet Name appears as the Calendar Name. My scenario is this: I have 5-10 projects going on at one time for one given client. So, if I am viewing all calendars at one time, the tasks/milestones are difficult to differentiate. Is there a work-around so that the…
-
Publish Calendar View
Is there way to publish the calendar view only? I am needing to share just a bit of data in a calendar view only without sharing the entire sheet. Thank you in advance for any help.
-
Turn off display of weekends on Calendar view
I do not want weekends to display on the Calendar view of a task list, but I don't see any way to do this in the properties. How is this accomplished?
