-
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.
-
Unicode Text Symbols are extremely useful
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.…
-
Formulas and Data Rollup
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…
-
Manage time entries based on previous ones
Hello! The use case I am trying to enable is that when a user makes an entry it should not exceed a set cumulative time (eg 120 minutes). So user 1 enters 90 minutes, user 2 enters 40 minutes in the cell below it which exceeds the alloted time by 10 minutes. Can this trigger a warning or validation that prompts for a…
