-
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",…
-
Remove Cell Linkage
I had previously created a sheet that inputted data via cell linking. However, the use of that sheet is no longer needed so I deleted it. The problem is that the sheet that was 'pushing' the data still shows the outgoing cell link. How can I remove the cell linking?
-
Invalid Alert/Notification
I am receiving notices of invalid notifications within various Smartsheets. When I log in, all of my rules for alerts are there, but the email recipients have been removed. I am the workspace and sheet owner; however, when I had a co-worker review the alerts within the same sheet the email address are there and no invalid…
-
Feb 12, 2018 Skipped
All of my tasks are skipping over and not including this date (yesterday) in their calculations. I do not have this set as a holiday in the main settings. Is there a holiday/day off setting for the specific sheet?
-
Dashboard widgets - Charts
I just want to tell everyone that with the additions of the chart widget, I am really loving our dashboards. I do wish the legends were editable and the selections didn't have to be side by side. I got around this by creating a second sheet and linking cells to the needed data. I could then create the labels I need and use…
-
Formula creates a String - Cell no longer blank/empty conditional formating
Hello, I have a particular problem, I have a series of cells that have formulas to detect the checked values of a series of Check Boxes, creating conditional formatting and inserting 'N/A' in certain cells: =IF([Assemblage Mecanique]8 = 1, "N/A", IF(Coupe8 = 1, "N/A", "")) after this check the cell retains a sting of…
-
Date range formula
Having an issue with date range formula. I am trying to accomplish returning values such as Q2 FY18. Q3 FY18, Q4 FY18 based on the date showing in the "Finish" column. However, I am challenged with the proper format to enter the date range, and then multiple at that. I initially used ... =IF([Finish]2>=10/29/2017,…
-
Pie Charts in Sights
Hi, Thank you so much for adding Charts to Sights! It appears as though the pie charts can only handle three data points, is this correct? Or am I possibly doing something wrong? Thank you!
-
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??
-
Charts & Graphs
Is this in your enhancement plan for Smartsheet? I don't find this feature like how I can create charts and graphs like in MS Excel. Thanks