-
Outlook calendar
I'm having trouble adding a calendar from a project that I setup in Smartsheet to Outlook. I followed the instructions in the help center, but every time I try to add the calendar in Outlook, nothing happens - the screen just blinks briefly, but the calendar is not available in my Calendar list on the lefthand panel in…
-
Help with a formula
Hello, This is probably a basic question... I am wondering how to input a formula that would allow me to calculate the value/price of something based on a drop-down selection. For instance, column A would have a drop-down options listing different tree species. For example, Redwood, Elm, and Walnut. Column B would have the…
-
Outlook Add In not working
I do not recall a Windows update occurring last week, however, this morning when I went to use the Outlook add-in, it is suddenly not working. Non-descriptive message: "Whoops! Our bad, something unexpected happened..." Anyone else running into this all of a sudden, or at some time in the past?
-
Can I create a If Then statement using a date in smart sheet?
I am trying to get a summary of duration for a particular resource within a particular month in smartsheet. This is unfortunately so that I can then input the hours into a custom ERP that lacks any intuitiveness. How could I do this? Here is an example Resource . Duration . Start Dates, End Dates LD 2 days . 8/29 8/30 AD 1…
-
Rounding
Hi, maybe a simple one: when I enter "0.00000872" into a cell - smartsheet displays 0.00001? How do I get it to display the actual value instead of the rounded value? Thx
-
Which webform created a row of data?
Does anyone know how to tell which webform generated a specific row of data on my sheet?
-
Correctly nesting an IF formula for automated flagging in row with unchecked column, and passed date
Hi there I am new to Smartsheet. I've learned how to write basic IF() formulas successfully. Now I am trying to create a formula to turn a flag on if the checkbox column is unchecked. Also, I only want the flag to turn on, on or after a given date. The flag type column is called Arrived? And checkbox column is called PM:…
-
Automated linking of added rows
Hi! I seem to have a major problem here and hope for you expert advice. My situation is as follows: 1. Team A and team B work collaboratively in Masterfile on first phase of the project with over 200 rows from all countries. 2. Team A also works with the other 7 country teams on a second phase of the project. 3. All teams…
-
Weekly columns
Hi there I think I am missing something here. I want to set up a list of tasks which will be due in certain weeks of the year and are repeated. For example. * Review website pages... Second week of each month * Write a blog article: Last week of the month * Post Facebook update: Each week. Do I set up 52 columns with the…
-
Split Screen for scrolling on Reports used in Dashboards
It would be helpful if you could scroll through the Gantt view of a report, separately from the Task view, when looking at a report that is embedded within a Dashboard. Today, there is only a single horizontal scrollbar and you can quickly lose sight of the associated tasks as you scroll to the right to see everything in…