-
Formula help...can this be done?
Column A is a date column. Column B tells us if we have scheduled Column A so it will sort into the right report. The formula in Column B needs to state that if Column A is a date, then the value is YES; If Column A says "Not Scheduled" it is No. Otherwise, Column B will remain blank. Can that be done? Blessings, Loann
-
RYG balls based on dates of activities completed
I have been following some threads discussing how to use RYG balls in conditional formulae based on a date column (i.e. green if the date is in the future, yellow if it is today, red if in the past, etc.), and those are very helpful! I would like to do the following, however, and I cannot find a thread that addresses this…
-
Text/Number column is editing my number
I input the number 2800.06610 and Smartsheet edits my number to 2800.0661 which means it is eliminating the zero. This column does not have any conditional formating. What am I doing wrong?
-
Setting up a Point of sale Sheet
Good afternoon, I was thinking of setting up a POS/point of sale sheet on excel. I googled it and found instructions on how to do it. But the person that was nice enough to post the information wrote it assuming that everyone knows how to enter Macros etc.. Then it came to mind that I should check here. I did speak with…
-
Enhancement Request: Batch Updating in App
Hello - It would be great if a user can update multiple columns (status, dates, etc.) by being able select two or more rows and selecting a "batch update" button to update all of the selected rows at once. Currently, user has to select the column to change, then update a particular field, then repeat if multiple fields…
-
New Row notifications via Send option
I want to use the "Send" option to send an email to the user each time a new row is entered, automatically. I have used the Notication Alert but it accumulates the rows in the same email.
-
Tracking articles
Does anyone have a template that works to track professional articles, books, etc. along with notes as you would find in a bibliography?
-
Sharing out Statistical Data
Hi everyone, What templates would you recommend for a report exclusively showing statistics? No date information will be included in this report (beyond the name of the month); however, there are three layers of statistics I need to share out by month. Any ideas? I look forward to hearing any and all suggestions- Alyssa
-
Using smartsheet for grant writing
I am a grant writer at a nonprofit and my development team uses smartsheet. I am at the beginning stages of using smartsheet and want to use it for EVERYTHING related to my grant writing (calendar, deadline tracker/notifier, links to emails, links to webpages, task list, grant applications, anything else you can think…
-
Limit View within a Sheet (using Web Forms)
Hello, New to Smartsheet. We would like to utilize a web form to allow customers to place orders/requests whereby the web form would populate the smartsheet for ONLY OUR INTERNAL visibilty/tracking of all requests combined. Currently, when I test this I am brought back into the sheet where I can see ALL requests. Does…