Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please
Visit the Current Forums.
Discussion List
SmartSheet Jira Integration
Hi all, I'm new to smartsheet and have also purchased their Jira integration. I'm curious as to how many others here are using this integtation? There's a lot of quirks with the integrations so wanted to see what others thought of it and how they're using it. Cheers, Imran
Countif rows meets multiple criteria
I'm new to Smartsheet, and I'm trying to count the number of incomplete tasks by SME area within a task list. How do I write COUNTIF formula that will count a row IF the Status column does not equal Complete AND the Area column equals Vocab? The ultimate goal is to depict on a Sight the number of incomplete (i.e., active)…
Alerts - Notifications to Groups
Is it not possible to set up a Notification alert to be sent to a Group? I only see the ability to send them to individual users.
Archived Community Post: Why am I asked to log in to Smartsheet to use Community?
Hello, I am wondering why I am asked to log into Smartsheet if I have clicked on Help from my Smartsheet window? Shouldn't Smartsheet know I am logged in since I accessed it from my already logged into Smartsheet? Thanks!
Prioritize/sort rows (possible feature request)
It is possible to drag 'n drop rows to change their order, but if you order by some column this "index order" is lost. I need some way to prioritize rows, with the most important at the top. I can do this by adding a column of type number, and manually enter the index for each row, but this is rather cumbersome. What I…
cut and paste / drag and drop images
When will cut and paste / drag and drop images be available (such as excel)? for quick user testing documentation and screen capture, this is very important. the need to save off every pic, name it, reload it, is not user friendly.
Formula for a future meeting date (after today)
Good morning - I have a series of columns with scheduled "future" meeting dates. I want to populate one column with the date of the next scheduled meeting. Have tried importing the formula which works in Excel over, but Smartsheet keeps on saying "INVALIDOPERATION. Help please !
Auto Lock columns or rows through formula
I want to know if it's possible to create a conditional formula (or something like that) that as a result Lock the row or the column. When the user's filled the entire row I want to lock it from other changes, automatically.
Printing Calendar by proper months
I'm trying to print a 5 month calendar by proper months. I keep getting months overlapping on a page. Is there a way to keep each month separate on each page of a print out?
SUMIF condition is met
I have a billing projections sheet that I am trying to figure out how to sum (total) the Current Year to Date billing of a project manager. I have a Project Manager column and Billing CYD column. Here is the formula I have so far... =SUMIF([Project Manager], Name of Project Manager, [Billing CYD]) Obviously this does not…