Join the Smartsheet Community
Find answers to Smartsheet questions, learn about project management best practices, discuss the future of work management, and get how-to guidance for every Smartsheet use-case from fellow users and Smartsheet experts.
Discussion List
-
Copy values from a formulaIn Using SmartsheetHello everyone I would like to extract and keep only the value from a field caluclated by a formula : For example : - When the row is added, there is an automatic formula in my column that gives me the result 5 - I want to extract only the…
-
How to make the symbol show instead of the word in a formIn Using SmartsheetHi, I'm working on form entry for a survey and I'd like them to rate in a star system. I'm able to change the column type to symbol with stars, but in the form the selection is word based (one, two, three, etc) instead of star selections.…
-
Creation date column that breaksIn Using SmartsheetHello everyone, I have a problem with a sheet form and I can't find a solution on the community. Here is the use case : I have a sheet with a "creation date" column that is automatically generated. I added a form, and each time …Answered - Pending Review 4 views 4 comments 0 points Most recent by Corentin Dal Farra Using Smartsheet
-
Modifying rows in a form entry sheet with formulasIn Using SmartsheetHello everyone, I have a problem when I change some date in rows in my sheet, here is the example : A user fill information in a form, and then a new row is added in the sheet related to the form On that sheet, there are a lot columns that…
-
Jira to SmartsheetIn Using SmartsheetHello, In a previous life I used the ceptah bridge plugin to link Jira information to MS project. Is a plugin necessary to export Jira information into a smartsheet gantt chart? Any information would be appreciated. Regards, Ch…
-
Gathering data from 1000 sheetsIn Using SmartsheetHello, i have this question: We have more then 1000 sheets with some project progress calculated in certain cell. Then we have one master tracking sheet with 1 line = 1 project. What i need is: Link this progress number from each sheet to …
-
Form Notification - Email AddressIn Using SmartsheetHi, I have created a Smartsheet's form with an automated process behind it that sends approval requests based on certain criteria. Is there a way to change the naming on the email that people receive so instead of people receiving it as Na…
-
Conditional Logic on FormsIn Using SmartsheetHi I currently have conditional logic on forms that is working as I expected. I have a type that has Risk, Action, Issue I have additional columns for a) Description, b) Related Risk, c) Related Action d) Related Issue, e) more informati…
-
Sync a column change in multiple reportsIn Using SmartsheetI dont think Ive seen answer to this, but I have multiple reports in the same format that are used to separate different sales reps (not internal so current user wouldn't help). If I need to add a column to all the reports I have to do it …
-
Column formula editIn Formulas and FunctionsI was able to convert a row formula to a column formula. However, now I need to edit it and am getting the message that only the sheet owner and admins can edit. I am the sheet owner. What do I need to do to edit the column formula? Thank…
