-
Nested IF with dates
Hi, I'm new to smartsheets and looking for some help with the nesting of IF commands so that I can advance a date based on the last date a review was carried out. So IF the "frequency of review" is any of "3 yearly, 2 Yearly, Annually, etc..", then take the "last review date" and add the appropriate number of days. I can…
-
Count number of Values Selected on a Contact list
Good morning, I have a column which is a contact list. My contact list is populated with users and email adresses. I'm willing to know the number of assigned people (i.e. for a given task, how many Values Selected on a Contact list). When I use count, it erroneously returns one (if one or more values are selected). Is…
-
Sharing Workspace
Hi all! When sharing workspace to new user, is it enough just to enter his email address into sharing window or i have to add user via user management? TIA
-
I Need a Construction Daily Report Template
I am a construction project manager and I am new to Smartsheet and I'm trying to create a Daily Report template. I can search the web for Smartsheet Daily Reports and I find several "templates", which all say "Smartsheet" on them, but they are microsoft excel files. When I try to import them into Smartsheet, they never…
-
Stacked column bar graph
Can you set a Stacked column bar graph to NOT show the total of numbers from columns, but just the largest number? Example: Drawn sqft - 2,283,197 surveyed sqft - 1,948,073 contracted sqft - 15,000,000 Currently the stacked bar graph shows a total for all three at the bottom. Thanks, David
-
print row with attachments
Hello, is is possible to print a row and include the attachments into the file also?
-
Bad Space in Dropdown List in Form
In creating a new form, and utilizing a drop down list, Smartsheet is adding an extra space which users can select when completing the form. I have created a dropdown test using four values. When creating the form I can select any of those values as the default...in this case "1". Then when publishing the form, users can…
-
Submitting Forms During Maintenance?
When Smartsheet goes down next Sunday, will we still be able to submit update requests that had been sent out before the scheduled maintenance? I am scared of spending a lot of time filling out a form and having it go nowhere when I press submit. Asking about update requests specifically. Thank you
-
Importing a .csv file as a smartsheet via the API
Hi, When I import a .csv file via the API, some of the column types are thrown off. I have one column that is strictly text (should have the type TEXT_NUMBER), but smartsheets is assigning that column the column_type PICKLIST. How do I prevent this from happening during import? Having to always import, then find the…
-
Form Help (Linking From Google Forms)
Hi all, New Smartsheet user here trying to figure this out. I have a Google form, and I want to share certain individuals on the responses, but because there's multiple options with branching responses, I only want to share them on some of the responses, and I want to do it in a new, separate sheet so it's not confusing. I…
