new feature on engage conference:approval request
Hi, I have difficulty to understand new feautre of approval request. I am a property management company and every month need to upload financial report to client web site. Accountant create financial report, then account manager need to approve, after account manager approve, client approval, them mail room will mail…
Smasrtsheet freezes and crashes Chrome
Today I created new sheet and it started to freeze when I click anywhere on this particular sheet, which is almost empty. Other ones seems to be ok, but this one I can't use at all. Anyone faced similar issue? I have restarted my PC, etc, but still nothing. Yet, I had to present this sheet today to my boss, so you can…
Formula: Look Up for two value
Hi, This one is pretty easy in Excel but I have no idea how to do that in SmartSheet. I have 3 columns in SS: Fruit, Brand and Price [Fruit]1 is Apple , [Brand]1 is ABC Ltd. [Price]1 is 100 [Fruit]2 is Apple , [Brand]1 is XYZ Ltd. [Price]1 is 50 [Fruit]3 is Pear, [Brand]1 is ABC Ltd. [Price]1 is 100 I want to have formula…
Is it possible for start date of a task to be based on dates tied to one of two other tasks? E.g. Task 2 must start not more that 10 days from completion of Task 1. Under normal circumstances, this allows task 2 to start not more than 10 days from start date of task 3. If start date of task 3 must be accelerated, however,…
Engage Conference on Sep18
Hi, May I ask does anyone join Engage Conference? I know that people can book one-on one design desk (30 minutes). One issue bother me long period of time: How to update existing SmartSheet by Ms Excel. As I open new smartsheet, I usually import Excel. However, after import excel, if there is info change in excel, you need…
Cross referencing two Sheets
Hi All I am currently using a web form to collect data for a staff onboard systems which is working great, however, I need a way to cross-reference the data coming in from the form to a list of people I am expecting. until the vlookup feature arrive later this year any ideas on how to do this would be greatly appreciated…
Has anyone used SmartSheet to capture organizational hierarchy or some type of org chart?
Does Smartsheet keep previous versions of spreadsheets?
I am wondering if smartsheet keeps previous versions of spreadsheets on the off chance of the sheet being completely deleted?
Edit content in Sights.
I just started using sights. I see that it is not possible to edit individual cell directly from sights, or am I mistaken? Is there a way to do this? It would be very helpfull if I could. I would also love to be able to edit the comments field directly from sights as well. Is this possible?