-
Counting criteria from a multiple drop-down column across multiple sheets
Hello, I'd like to show the number of tasks each person on my team is working on in a roll-up sheet. On all my project sheets, the 'Assigned To' column allows multiple names. When I attempt to aggregate the number of times a name appears in this column on all the referenced sheets, I get an incorrect number (no formula…
-
Is it possible to add a delay to a task if it doesn't have any predecessors ?
I have few tasks in my sheet, which are not independant of other tasks. The dependencies have been swtiches on in the gantt view. Is it possible to add a delay to these tasks without manually changing the dates ?
-
Using daily report template
We're new user trying to understand how we can use daily schedule template to repeat itself on-going basis. When I go to settings it is grayed out so there goes that option. Spreadsheets are not something I've used too much and support is slow getting back to me
-
Ideas for how to automate distributing Meeting Agendas and Minutes ?
Hi, I am trying to create a meeting minutes template which both facilitates taking minutes against an agenda and also automates distribution of minutes to 'Attendees' when ready. I am using multiple rows to list Agenda topics (under a parent Meeting Title line) and then logging the minutes for each topic in a neighboring…
-
Confirmation of Automation Email Needed - Proof
I am trying to prove that the automation workflow alert that was set up actually sent out to one of my users. I can go to the View HIstory section of the Control Center intake sheet, but it does not show proof of who received the automation. Is there a way to see how the system interacted as a way to prove that the…
-
Addition of resources to Smartsheet
Greetings. The previous system admin of our Smartsheet account has left the organisation. How do we change the system admin now ? There is a need to add more resources to our account and we are not able to do the same. Kindly provide suggestions on what to do. Thank you
-
Sheet exceeded the maximum recommended size
Has anyone received this error message before? What are the options for large data?
-
Can 'Working Days' settings vary per assignee in sprint planning?
Hi! Working with one of the Smartsheet sprint planning templates and would like to be able to set different working patterns as two parties contributing to the sprint. i.e. Team 1 work Mon-Friday 8 hour day but Team 2 work everyday except Friday. Setting the working days in Smartsheet for either Team means that the…
-
Week Number stopped working
Hi All, I'm a little stumped, I have a formula that worked great until last week when it stopped working. I figured it was just because it was week 1 and week 52 in the same week and figured it would all start working this week. No dice, any help is appreciated. The formula is a helper column that is meant to count the…
-
How to include double quotes in the output of a text formula
I am trying to combine several text elements into an image attribution for each row on my sheet. Here's my formula: ="American Society for Microbiology " + Category1 + ". " + Title1 + ", " + SubmitterFirstName1 + " " + SubmitterLastName1 + IF(ISBLANK([Co-creator #1, Name]1), "", ", " + [Co-creator #1, Name]1) +…
