-
Automated Alerts & Actions
OH MY! You all are so close... I've been waiting on the day that I could save my alerts and notifications to a template for over a year now. On average, I create about 10 new sheets every week, and each sheet consists of 2 REMINDERS and 8 NOTIFICATIONS. We use these sheets to track new parts to be manufactured, and once we…
-
INDEX and MATCH #invalid value error
Hi! I'm trying to apply a formula we got to work in Excel to our Smartsheet. The goal is to look at a range (Column "1" through Column "Column64") in a single row and find the non-blank cell farthest to the right and return the value from the same column in row 2. (Row 2 was created to replicate the name of the column…
-
Notifications for Comment Updates
Hey SS community, Our company is looking to phase out Basecamp and solely use Smartsheet to manage our ERP implementations. One feature that keeps us holding on to Basecamp is their UI for discussions. For those who have not used Basecamp, a feature we are partial to in discussions is the ability to choose who receives an…
-
Resource Allocation in Parent Rows
Does Smartsheet allow resource loading parent rows? I am trying to assign parent rows to staff and allocate percentage on the parent row, but it does not allow allocation entry on the parent row. I do have resources enabled on the sheet. I do not want the parent row to sum the allocation percentage of the child rows.…
-
Need a workaround so Parent Rows stay children rows when sorting
As I understand it, Smart sheet does not have the function to keep parent rows with children on reports like on the filter function. Which baffles me! Is there a work around that anyone can recommend for our situation? We currently have a Ready@Spike Date column. This will indicate when each child row will be completed.…
-
Can I have a workspace sitting within another like the top level home
Wondering if it's possible to have a workspace sitting inside another one, like it is on the home tab? E.g. Home - Subsidiary 1 - Function 1 and then Home - Subsidiary 2 - Function 2 If it is possible would the embedded workspace take on the access permissions of the higher one or could these be specific
-
Nested CountIf statement help needed
Hi, I need to create a formula where if a box is checked in one column, a figure in another column gets included in a sum in another cell at the bottom of the column with the numeric value. This is what I've got, but I'm getting error messages: =COUNTIF(QTR:QTR, "True", SUM(Blackline:Blackline)) I'm not sure exactly what…
-
Formula help
I have a date column for bid due dates. I'm trying to create a formula that gives me a count of how many rows have a due date coming up in the next 30 days. So far nothing we've tried has worked, not sure why. Does anyone here have a suggestion?
-
Embedded form not redirecting after successful submission
Hi I have copy and pasted the embedded form code into our wordpress website and can successfully receive the entries from the form through the website to our smartsheets account. The problem is it hangs for the person/visitor entering the information in the web form and stays showing a message "Your submission is being…
-
Parent-Child Formula for Percent Comnplete
Good Day All: How can I change the following formula below into a parent child relationship so if I add additional rows, the parent will automatically include the child in the calculations for overall percent complete. Does anyone have the Smartsheet % Complete Formula that is hard coded within the Project Settings? Thanks…
