Discussion List

  • IF then statement
    In Formulas and Functions
    Hi, Fairly new to smartsheet, I am looking to do the following: If 'Drop Down A' is set to 'No', then set 'Date Column B' = 'Date Column A + 30' If 'Drop Down A' is set to 'No', then set 'Date Column D' = 'Date Column A + 14' If 'Drop …
    907 8
    907 views 8 comments Most recent by Rana Walker Formulas and Functions
  • Time Tracking
    In Using Smartsheet
    I'm new to SmartsSheet and don't see an obvious way to track time, and have it recorded against a task Personally not too fond of % complete - to often I've seen people say/think (legit or not) that they're 90% done, and the last 10% take…
    85 3
    85 views 3 comments Most recent by Mary Royston Using Smartsheet
  • Why can't Smartsheet work in an Ipad Browser?
    In Using Smartsheet
    I understand there is an IOS app but it does not come close to the computer browser based environment, it doesn't perform as well, doesn't have matching capability, heck even the user interface is different. I  do not care for the app  but…
    1730 19
    1.7K views 19 comments Most recent by iOSUser Using Smartsheet
  • Workflow to Update Date to TODAY() until another cell = 100%
    In Formulas and Functions
    I have 2 cells in a column: Which displays a % from 1-100 Which should show a date Is it possible to use a workflow or other automation to daily (at 12:01am or any other time) update the date field to TODAY(), but to stop updating it once …
    32 4
    Answered ✓ 32 views 4 comments Most recent by BrianWong Formulas and Functions
  • Using SmartSheet for Discussions/Messages/Threads
    In Using Smartsheet
    Hello! We've been using SmartSheet for the last ~9 months and love many of its features (e.g. project plans, Risk, Actions, and Issue Logs, etc). One use case that we haven't been able to find a great solution for, however, is basecamp li…
    213 3
    213 views 3 comments Most recent by Kerry Mitchell Using Smartsheet
  • Calculate the time between two dates by days, hours and minutes
    In Formulas and Functions
    Hi, I am trying to implement the following formula from my excel spreadsheet into my smartsheet: =INT(O2-Q2)&" Days "&HOUR(MOD(O2-Q2,1))&" Hour "&MINUTE(MOD(O2-Q2,1))&" Minutes" Basicall…
    3109 26
    3.1K views 26 comments Most recent by Julie Barbeau Formulas and Functions
  • % Allocation
    In Using Smartsheet
    As a new user, I found that the % Allocation column does not respond to input from the Duration column, as seems intuitive to me. After reviewing community comments, I find that the % Allocation functionality in Smartsheet does not actual…
    EdL Profile Photo EdL
    2184 9
    2.2K views 9 comments Most recent by Alon Dagan Using Smartsheet
  • Time Tracking - Hours and Minutes
    In Formulas and Functions
    I was working on a way to track some task hours and minutes... came up with this: One of the problems I ran into is that if you put "00" (double-ought) or any minute with a preceding zero, it would error. You can see the work-ar…
    1585 5
    1.6K views 5 comments Most recent by L_123 Formulas and Functions
  • Username + Password authentication is still working after disabling in Admin Console
    In Apps, Integrations, and Add Ons
    Hi all, We are using Azure AD to authenticate into Smartsheet. Recently, I disabled the Username + Password authentication option (including Administrators) with the goal of users only being able to use SSO. However, users are still able …
    Answered - Pending Review
    53 1
    Answered - Pending Review 53 views 1 comment Most recent by Genevieve P. Apps, Integrations, and Add Ons