-
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?
-
Repetitive Task List Instantiation - Editing Multiple Tasks From a Master List
A common experience we encounter is when we have long, identical lists of tasks (7 or more), indented under many parent titles, that need editing, as shown below: PARENT ONE * Task ONE * Task TWO * Task THREE. etc. * PARENT TWO * Task ONE * Task TWO * Task THREE. etc. We have many PARENTS with identical lists of tasks that…
-
Attachment Permission
Is there anyway to share a sheet but not certain attachments? I have all my sharing permissions set but there are certain attachements I do not want available to certain users. Smartsheet is working great for my team with the exception of attachments.