I'm building a report that will show things that are happening TODAY and in the FUTURE. I can build each of those separately, but together seems to be an issue. I built a filter based upon date being …
I was wondering if it is possible to create a task whose duration is determined by two predecessors, one from backward planning and one from forward constraints. I would like to use this, among others…
I am trying to get a sum of % completion based on a Checkbox. For example, if someone checks off 3-4 of the boxes, and I know the weighting for each box (as shown in the IF statement, I would like to …
Hello, This is probably a basic question... I am wondering how to input a formula that would allow me to calculate the value/price of something based on a drop-down selection. For instance, column A w…
I am trying to get a summary of duration for a particular resource within a particular month in smartsheet. This is unfortunately so that I can then input the hours into a custom ERP that lacks any in…
Hi there I am new to Smartsheet. I've learned how to write basic IF() formulas successfully. Now I am trying to create a formula to turn a flag on if the checkbox column is unchecked. Also, I only wan…
Hi there I think I am missing something here. I want to set up a list of tasks which will be due in certain weeks of the year and are repeated. For example. * Review website pages... Second week of ea…
Hi All I am currently using a web form to collect data for a staff onboard systems which is working great, however, I need a way to cross-reference the data coming in from the form to a list of people…
Hello! I'm curious what would be the best way to report a cells previous vs current value. For example, last month we had a status set to 15%, and this month it's updated to 20%. I'd like to see the 5…
Another formula-related question. Is there a maximum number of options (not sure of the correct term) I can use with the IF function? I'm getting an #UNPARSEABLE error. Here's the formula I'm trying t…
