-
Helpful Formulas for Larger Schedules
Here are a few formulas which are perhaps a bit more advanced, but have really helped our organization. I have also placed them into a published sheet found here, where you can see the formuals working. Weeks to Start Calculates the number of weeks away a task's start date is. This works for any date, such as a task's…
-
Using SUMIF when column is not blank
Hello, I am trying to sum only the values of the children in one column for which the corresponding cell from another column is not blank. I tried this formula: =SUMIFS(CHILDREN(Amount25)), (CHILDREN([Date Paid]25), NOT BLANK), but it did not work. Is it even possible? Thanks!
-
Functions for net present value / internal rate of return
Hi all, I want to do some financial calculations within smartsheet but I can't find functions that support the calculation of * - net present value or - internal rate of return I haven't found hints neither in the smartsheet help for functions nor in the templates or here in the community. Anybody had the same problem and…
-
Need help with an IF AND statement
=IF(AND([Required Weld Size]4 = 0.25, [Actual Weld Size1]4 = 0.5, 0, 1)) I am not able to get the above working. IT comes back imbalaced and I have played around with it with not luck. Can anyone lend a thought?
-
Formula help...
I've tried a formula that seems to work, in that it doesn't give me the lovely "Unparseable" or "Missing Operator" message. Here's the scenario: If Column A (text column) contains "These words" then Column D (date column) = Column B (date column). Column A does contains the needed words, and Column B is a date. But Column…
-
Formulas
Hi I need to create a formula whereby the number of checked boxes within a column are subtracted from a certain number. Is that possible? Liz
-
Formula Help
Hi. I am a project manager for a design build company and I am creating a template to use to forcast the labour required on a job that automatically decreases based on the percentage complete. I am wanting to add a formula to one of my sheets that will automatically populate up to 4 column cells based on an option chosen…
-
Assigned to = sheet owner?
Is there a formula or reference for an assigned to column that would automatically be the sheet owner? I'm trying to setup an automatic reminder email to a sheet's owner two weeks before a milestone date.
-
Gantt Sheet - Linking Dates
How can I generate the sub dates on a Gantt sheet using the duration? I would like to be able to copy my project and the subdates automatically generate from the head date? This could be generated by the duration. For example If the Head start date is 1/3/2016 I would like the sub dates to auto generate from the duration…
-
160 character limit in field (used for sms)
Is is possible to set a l60 character limit to a field? The reason for this is that we collect texts from users (mostly by web form) that we will use for sms, but usually they write more than 160 characters which leads to extra work.
