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 …

  dsmartsheetuser

  01/20/22

  907 8

  907 views 8 comments 0 points Most recent by Rana Walker 01/20/22Formulas 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…

  tcgibson46341

  01/07/22

  85 3

  85 views 3 comments 0 points Most recent by Mary Royston 01/07/22Using 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…

  Fly.on.the.wall

  12/08/21

  1730 19

  1.7K views 19 comments 2 points Most recent by iOSUser 12/08/21Using 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 …

  BrianWong

  12/03/21

  Accepted

  32 4

  Answered ✓ 32 views 4 comments 0 points Most recent by BrianWong 12/03/21Formulas 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…

  chadwicktr

  11/22/21

  213 3

  213 views 3 comments 1 point Most recent by Kerry Mitchell 11/22/21Using 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…

  LouiseM

  11/11/21

  3109 26

  3.1K views 26 comments 0 points Most recent by Julie Barbeau 11/11/21Formulas 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

  11/08/21

  2184 9

  2.2K views 9 comments 1 point Most recent by Alon Dagan 11/08/21Using 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…

  Ezra

  11/02/21

  1585 5

  1.6K views 5 comments 1 point Most recent by L_123 11/02/21Formulas 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 …

  tross417

  10/26/21

  Answered - Pending Review

  53 1

  Answered - Pending Review 53 views 1 comment 0 points Most recent by Genevieve P. 10/26/21Apps, Integrations, and Add Ons