Support
Discussion List
-
Workaround for Sheet Reference Limit?In Using SmartsheetHi everyone, On our project we have two sheets, a project plan which contains around 50 items, each containing around 9 sublevel actions. We have a separate sheet that we were manually maintaining in excel containing all of these sublevel …
-
How to include an if statementIn Formulas and FunctionsI have a vlookup formula. =VLOOKUP([Attribute Name]@row, {Standards List - Enhanced - Business Rules Range 1}, 4, false) . I need to be able to use this formula and check another column based on the version number. I need it to pull in x i…Answered - Pending Review 12 views 1 comment 0 points Most recent by Paul Newcome Formulas and Functions
-
Forms with formulasIn Formulas and FunctionsI'd like to include a formula (hidden) in a Form that includes a vlookup to another sheet with known email addresses. This would save the user time on entering their email when completing the form. The email is used to contact them back th…
-
Sub tasks appearing in an Uncategorised columnIn Using SmartsheetWhen I setup sub tasks in Smartsheets Card view, they appear in an Uncategorised column as separate cards. How do I stop this? Thanks
-
Remove the "0" in the column formula cell.In Formulas and FunctionsHelp please! I am trying to put the item name (column name) in a cell if it's listed as "Complete". This is working for the most part, but if none of my IF criteria matches, it shows a "0" in the cell or if only the las…
-
Dashboard Chart Widget Axis changes with each refreshIn Formulas and FunctionsThe axis label on the dashboard chart widgets consistently changes with each refresh and will not maintain the order that it is in on the Report. This is pulling from a summary report. Occurring on a monthly report widget and quarterly. …
-
Formula to add "No" to a blank cell, but leave value if not blankIn Formulas and FunctionsOn a Smartsheet project intake form, I have several Yes or No dropdown selections. If Yes, the user must answer additional questions. If No, they do not and those cells are left blank. Auditors do not like Blank cells, so I'm looking fo…
-
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…
-
Access Issues with Smartsheets?In Using SmartsheetHi All, I have a paid license on Smartsheets and need to invite free users to certain spaces/documents to collaborate on work documents. However, when I share to users (both free and paid) with admin or editor access, they can't edit the d…
-
How can I share a report to an user without sharing him paper, source of report?In Using SmartsheetI would share some data in a report with an user but I do not want share with him the paper, source of report. The aim is to use report as a tool able to visualize data for all users and to track and modify data on a paper used only by our…
