-
Sumif / Countif
Hi All, Still new to SmartSheet so help would be appreciated I am trying to sum a column if another column contains specific text "street lighting" I have come to =COUNTIF(Team:Team, "Street Lighting," ([Past Due Date]:[Past Due Date]) but it comes back with Unparseable and I am lost, It's probably something simple that i…
-
Tasks on Track and Off Track Count
Good Afternoon All, The Vice President has decided that for each project plan he wants to know the below information A count of the number of tasks that should be in progress (using start date) A count of the number of tasks that should have started and havn't (using % complete and Start date) A count of the number of…
-
Need a How-To: IF [blank addends], blank, IF [values], sum
I'm working with this formula, which gives me [Expected Completion Date]: =[Planned Start Date]1 + [Expected Days Duration]1 Without values in Planned Start or Expected Days, I get #INVALID OPERATION in the Expected Completion. What's the simplest IF/THEN to use that will return a blank in EXPECTED COMPLETION if we haven't…
-
Simultaneous use of form by multiple users
I am using a form to collect sign up information at an event. We will have multiple computer stations set up with the form. I wanted to ensure that we won't run into any issues with simultaneous usage / submittal of the form by multiple users. Thanks!
-
Return Column Name using a Formula
I have several columns I use to track dates for different steps in a process. i.e. Ordered, Delivered, Installed. Is there a formula that will return the column name of the latest date across these columns. For instance, Ordered = 8/4, Delivered = 8/15, Install = n/a. In my "Status" column I'd like to return "Delivered"…
-
Vacation/Out of Office causes resource over allocation?
I hope someone can help me out here, or tell me how they approaches this :) In my department we have some issues when people are on a project and then going on vacation or out of office, it will show as if the person is 185% over allocated. (for example if it is 85% project and 100% vacation) Is there any workaround on…
-
Action Row Indicators in Reports
I have created a report that shows resources in a Gantt view. This works well however, what is not available is the useful row indicator showing a user is over utilised on a day. Using the resources views is OK but it doesn't make easy reading as you can't see the tasks and only the sheet name. Anyone got a workaround for…
-
Reminders needing the same logic as Notifications
I've found a limitation of the reminders and notifications and would like to request that one or the other be tweaked to solve my problem. I want my contacts to receive an alert before/on/after a date but only if another columns checkbox is unchecked. Originally, I thought that a notification would work. I set up many…
-
Automated Email updates-- SUGGESTING MORE EFFICIENT FORMAT FOR COMMENTS
Hi All-- I LOVE SmartSheet but I really wish the AUTOMATED emails that are sent that include the COMMENTS section could be setup like the emails that can be sent from manually selecting the "send" function on a row; which places the message ON TOP of the row information. Said in a simpler fashion--PLEASE PUT THE COMMENTS…
-
Using Smartsheet as the only tool vs SharePoint, shared drives and OneNote
Our department is looking at how we file electronically. We have used a combination of OneNote, SharePoint, Shared Drives and we just started using Smartsheet. Smartsheet seems to allow for all communications, files, etc to be stored there. Has anyone moved to using only Smartsheet for everything that has anything to do…