Technology
Discussion List
-
IF then statementIn Formulas and FunctionsHi, 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 …
-
Time TrackingIn Using SmartsheetI'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…
-
Why can't Smartsheet work in an Ipad Browser?In Using SmartsheetI 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…
-
Workflow to Update Date to TODAY() until another cell = 100%In Formulas and FunctionsI 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 …
-
Using SmartSheet for Discussions/Messages/ThreadsIn Using SmartsheetHello! 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…
-
Calculate the time between two dates by days, hours and minutesIn Formulas and FunctionsHi, 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…
-
% AllocationIn Using SmartsheetAs 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…
-
Time Tracking - Hours and MinutesIn Formulas and FunctionsI 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…
-
Username + Password authentication is still working after disabling in Admin ConsoleIn Apps, Integrations, and Add OnsHi 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 views 1 comment 0 points Most recent by Genevieve P. Apps, Integrations, and Add Ons