-
Forms - adding a URL to the "submitted" message
I read in Sharing and Collaboration: "Control what the form submitter sees after submitting the form. You can either display a confirmation message, reload the form so it can be submitted again, or direct the submitter to another URL." Does anyone know how to add a hyperlinked URL? Thanks!
-
Is there a way to replace data in spreadsheet without losing references ?
Dear all, I have a Table A, created in Excel file, which I uploaded to Smartsheet. I treat it as source material for multiple other sheets in Smartsheet using references, then those are used in Dashboards. Now, Table A has been updated since, I need to change that in Smartsheet but going 1 by 1 is out of question cause…
-
Using a master sheet to change multiple sheets
Currently, I have a project template that I use for opening a new location. Our company is typically working on 5 or more location opening projects at a time. When changes need to be made to the basic structure of the project plan (i.e. deleting a task, adding a task, adding a column etc.) this change has to be made across…
-
Why a column does not appear as a selection when i press the "View By xxxxx" in Card view
When I am in Cardview I go to Card View Settings / Fields to display. I select 4 fields to display. However, they do not show up as options when I want to change the views by different columns. How do I get these items to show up after I selected them in the Card View Settings? the columns are text/number columns I am…
-
Row Separators
We recently made the switch from XL to SS. Each row represents a purchase order. We 'group' our rows(POs) in to container shipments (multiple POs/container). When we were in XL, we would just leave a blank row in between container shipments - easier on the eye to separate one shipment from the next one. As there are now no…
-
IF formula and AND
Hello I am a novice on Smartsheet as well as formulas. I have created a sheet that tally's the results of survey. I created an IF statement to calculate the answers =COUNTIF({CCA Training Survey Range 5}, "strongly agree") and the next column is =COUNTIF({CCA Training Survey Range 5}, "agree"), etc. to the strongly…
-
Change Time into Military
Hi all - Looking for solution to a simple task. Using a form that shows date in this format: 8:00 AM, 9:30 AM, etc., Want to add a second column (that will be hidden from form) that changes this to military time. No calculations involved - only looking for the time conversion. Yes, we could ask for military time in our…
-
Color coding in calendar
Hi there- I have certain rows highlighted a color in my grid view but the color is not transferring to that task on my calendar view. What am I doing wrong? Thanks!
-
If then formula with different sheets
Hello, I am looking to create a formula that looks at the Tag Name/ID from these two different sheets. If they are the same, I want the Date Received in Full to show up in the Received by Van Ert column for that Tag Name. For example: The Tag ID in line one on the first sheet is 410-AE-1391B. The Tag Name in line 581 on…
-
Help - I'm on a trial of Smartsheet but I can't enter any information into any cell on any document?
I can't create anything. Its not frozen it just won't let me enter anything. My user is valid and I'm not logged in with another email address. Help:)