-
Locking Cells/Columns in a Report
Hi Smartsheet - I recently created a series of report in smartsheets that pull specific pieces of information for departments so that managers can see their respective things and provide updates. However, unlike a regular sheet, where you can lock certain columns so as to prevent users from being able to edited field, we…
-
Consistent sort and filter
The ability to automatically sort and filter is a must for us. right now we have to go through the pain staking task of removing the filter, setting up the sort, and then adding the filter back for each item we add through the web form. How do we automate this as it's 100% unnessary to ask all of our designers to do?
-
I would like to send daily reminders of a row to the employee of that particular row till the status
Hi, I want to send daily remainders of a row to the employee of that perticular row till the status colomn shows finished. The colomn names in my sheet are : 1, start date : system generated date and time( this is not visible in the reminder) 2.end date : we can utilize this based on the status colomn 3.emplyoee-1,…
-
Change parent row from import
We are looking at switching from google sheets to smartsheet and cannot seem to find a way to change the parent row in smartsheets. We have selected every option that we can find, but just not the right one. Note: We want the parent row to be our task name, so that it shows up in the calendar view. Currently it's a number,…
-
Amazon Web Services
Is the S3 vunerability patched yet so that we do not have a repeat outage like we did at the end of February? Or are we still at the mercy of AWS?
-
Can color codes in Smartsheet export to a Google calendar?
I have three status listings for my projects in Smartsheet - not yet started, under development and completed. Each one is color-coded differently (red, yellow and green). I also have exported my tasks to a Google calendar but all the items appear in the calendar in the same color. Is there some way of exporting different…
-
Combining COUNTIF and COUNT(CHILDREN) formulas
Is there a way to create a single count formula that will return the number of rows using two criteria? I need the number of rows with column A = Abby and column F = MONTH(@cell) = 2
-
Sumifs
Does anyone know how many criterion you can have with a SUMIFS? This formula works =SUMIFS([Conversion to $US]$21:[Conversion to $US]$385, [Cost Centre Description]$21:[Cost Centre Description]$385, [Cost Centre Description]6, [Fiscal Year]$21:[Fiscal Year]$385, [Fiscal Year]6) But when I add one more criterion such…
-
Combine tasks from different sheets into a single calendar view
How do I combine tasks from different sheets into a single calendar view? I have my sheets broken out by niche within my firm. I'm the marketing director of a CPA firm with oversight of marketing many niches; I'd like to see all daily responsibilities in a single calendar view. Is that possible? Thanks. Joe
-
Sum rows that are not children
I am creating a SS that contains a row for each event and below children for event expenses. The top/parent row calculates the sum of the children beneath it. I would like to create a Totals row that calculates the sum of all the top/parent rows. Is this something SS does?
