I am lookiing for a program to work with smartsheet to send texts or emails automatically for webform links.
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…
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…
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…
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 <…
Can a column be added that can display the remaining days of a task ? and How can be this done. Thanks
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 :)
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…
=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?
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…
