-
Troubles with inputting a value for notification
I am creating a sheet to keep track of a budget process. I am curious why a notification does not get sent out when I input a value by typing it in when using the "is one of" condition? The notification only works when I already have 100% typed in the column somewhere, then I have to select it from the drop down box. Why…
-
Conditional Formatting Do not modify current value if condition in other field fails
Without creating another column, I am trying to update a current value only if the condition is met in my modified by field. My formula (below) works when the condition is met. How do I tell SS to leave the current value as is if the condition is not met? =IF([Modified By]1 = Owner1, " ", Modified1) Background: Above…
-
sumif date is today to end of month
Trying to write a formula that doesn't need manual updating that basically sums a total amount for file that have a closing date from today to the end of the month. Seems like it should be fairly straight forward but I cant get it to work. The sheet has parent rows but i want to include all rows in all parent rows in the…
-
Consolidated SmartSheet
Hi all, I am pretty new to Smartsheet and in need of some help. We are using smartsheet for an upcoming budget task. I have created over 50 different sheets. In each sheet there is a column with checkboxes. I want to have a user check the box when the specific task is completed. My question is, is there a way to create a…
-
Revenue per month Formula extending beyond 1 year
I have a sheet that I have created to forecast revenue per month based on forecasted schedules and dollars/project. Currently this just goes for 1 year, but with projects now starting late Q4 2017 and going into Q1 of 2018, I am needing to revise this formula to add a year definition. Would love if someone could take a…
-
Microsoft Flow - Inserting a new row on a sheet with Dependencies enabled
Hi, I'm currently trying this out to see if we might use it more widely in my organization. I'm trying to insert a row using Microsoft Flow, but I am receiving the following error: * End Dates on dependency-enabled sheets cannot be created/updated. Please update either the Duration or Start Date column. Based on another…
-
LastChild() function?
Is there a way to display the value of a cell from the last row of children in a given parent row cell?
-
Formula Help
This might be simple, but I can't figure out a good formula for dates. What I have is a column with dates, and another column (Year) next to it that is hopefully an If statement. Something like IF the date is in 2015 THEN put a 15. I need this column so I can reference this Year column when calculating total investments…
-
Live Data Connector Reverse Upload
I have the data connector up and running. I am able to have it take info from Smartsheets and put it into excel. This is awesome because one I press refresh it updates everything in that excel file. The only question I have is, is there anyway that the data can be updated into smartsheets if I change it in excel? We have a…
-
Formula Help
I have a formula that says it is an incorrect argument. When I break up the two arguments they each work, but they are not working together. The error message is incorrect argument. I don't know why they work alone, but will not work together. Here is what it looks like when I added them together. Can someone tell me why…
