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…
=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?
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…
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
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…
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.
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…
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.
Please send me an email if you would like to be added to the workspace. kriswalsh@gmail.com I love Smartsheet's native symbols and use them all the time. That being said, there are times when I wish I had more options or flexibility with them. I am sharing the following with the hope that: 1. Someone finds it useful. 2.…
Hi, I am in the process of putting together a sheet that logs the amount of production each day. As a bit of background we are an aggregate manufacturing and contracting business and what i am trying to do is have a sheet that tracks the amount of production of each product per day. I have created a sheet with all the…
