-
are there 3rd party apps available to send text for webform links daily
I am lookiing for a program to work with smartsheet to send texts or emails automatically for webform links.
-
Smartsheet won't save changes after a sorting
This morning I did a sort on one of my columns so I could review and enter data easier. When I went to save the data Smartsheet told me it couldn't and to save data more often. I tried doing the sort and then saving after the first number update and I got the same error. The only way I can save my changes is if I don't do…
-
Employee Anniversaries
We use Smartsheet for a number of different departments, HR being one of them. I'm wondering if there's a way to conditionally format a "hire date" cell to change colour when an employee anniversary is approaching? There is currently an option to conditionally format for a date that is a certian amount of days in the…
-
Setting Up sheets to run multiple businesses
Hi I have 3 businesses that demand different work flows and I am having trouble getting my head around the best practice for how I should set up these sheets. Should I use one sheet to manage contact information for the 3 businesses and what is the best practice to link contacts to Quotes or jobs on other sheets ? Comon…
-
Nesting Formulas excluding future dates
Hallo Everyone I have a Nested Formula that looks like this. =IF((Eficiencia19) >= 0.9, "Green", IF((Eficiencia19) <= 0.7, "Red", IF((Eficiencia19) > 0.7, "Yellow"))) What it does , it automatically put a symbol, depending of the value of a cell. It does this independendly of the date. Green : >=0.90 Yellow: > 0.70 and <…
-
Column with Remaining Days
Can a column be added that can display the remaining days of a task ? and How can be this done. Thanks
-
web form for order form
I'm new to Smartsheet. Have created a sheet with a web form to be an order form for our customers. In part of the form I'm wanting to provide our customers with the functionality of entering quantities for our various products, how do I do that? Thanks :)
-
When will Smartsheet be able to produce comprehensive reports and link Gants charts into WBS's?
I'm an advocate of the intuitiveness of smartsheet and use this programme over other PM software for gant chart use. I find it is more user friendly, easier for collaborative use and the fact I can use this on all platforms. My question is, why does smartsheet not have the ability to produce WBS and comprehensive reports…
-
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
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…
