-
Formula - adding two columns based on a condition
I think I'm close but this is driving me crazy. I have an event code column and two other columns where I am collecting participation data on Saturday and Sunday. I would like to know the total participation for the weekend. The formula for just Saturday or just Sunday works =SUMIF([Event Code]:[Event Code], "CL021718A",…
-
Admin can't edit sheet title
Good afternoon, While out of the office a sheet title had to be updated, and my fellow license holder, who is an admin for the sheet, was unable to do so under her profile. The rename option is greyed out. The only option for her to make changes in my absence is to login to my account. I trust her completely, but it does…
-
Dependent dropdowns using Smartsheet Sync & Google
Hello, does anyone know is it possible to create a google form and link it to an existing smartsheet rather than create a new smartsheet??
-
Auto Sum last 6 columns
Hello ~ I'm calculating attendance and want to highlight inactive participants. Currently, I copy and paste =COUNTIF([20 1/6/18]3:[25 02/10/18]3, "P") each week as a new column is added. Is there a formula that will auto add new entires and also limit to the last six columns? Thanks!
-
Building A Sheet That is Agile Velocity Focused
It won't let me hyperlink a copy of it but here is the URL for those who trust I'm not trying to do anything scary. https://drive.google.com/file/d/0B8APP67r815BaVdmRkxrRlVKRDA/view?usp=sharing So this creates a gant shart that shows them waterfalling off one another (but only shows where they end and not begin) It also…
-
Assistance with a formula -- similar to VLookup
I’m not sure if this is possible in Smartsheet but I know the Community will know! For our Annual Meeting, I created a blank sheet that will help us manage our schedule and assigned meeting rooms. Some of the columns are: * Meeting Room Name (the name of the hotel meeting room) * Capacity-Conference (the capacity of the…
-
Items move to the bottom when marked complete
I'm helping my manager set up her "To Do" list and the way that she has been working is that she moves completed items to the bottom of the list, so that what she needs to do is always on top. Is there a way to set up Smart Sheets so that it automatically moves completed items to the end of the list? We know it can be done…
-
Primary column
A new user is wanting me to verify that you cannot reassign the Primary column once your sheet it set up and saved. I'm pretty certain the answer is "no." Blessings, Loann
-
Building Reports for Widgets
In a report, I want to change the column name "sheet name" to "Project" but when I double click on the column the rename option is not available.
-
Google Calendar creating two events for every task
When integrating my Smartsheet into Google Calendar it creates a second event for every task labeled "Edit Smartsheet Rows". I think this has something to do with making it easier to adjust the Smartsheet from the Google Calendar, but I don't need that functionality nearly as much as I need my team's calendars to have the…
