-
Operator
Hallo , I have columns A ,B, C. A and B have some formulas. so then it will show some values Now in C column i write formula A+B ... but says Invalid Operation... Is it not possible add two columns which has formulas
-
how to show only content in a multiple user sheet that was entered by the requester?
Lets say... Tom, Alex, Paul are in the field, submitting content for columns A, B and C to me through a FORM. This content goes straight into my master SHEET which also has column D, E and F with confidential information. Tom needs to make a change to his content after submitting the form. How can he re-visit his content?ā¦
-
do I have to grant access to the source grid for others to view reports?
Hi, lets say I have a sheet with 10 columns. 7 with general information, 3 with sensitive data. Now I want to share the general information with others. So I create a report with the 7 columns and share it accordingly. The people IĀ“m sharing it with keep saying that they are looking at blank pages. They might see theā¦
-
Are Conditions Mutually Inclusive or Exclusive?
Hi all, I have a workflow with various ramifications. I would like to know, with one line of evaluation (which has 3 conditions), will the trigger play if the 3 conditions are met or with only one, it will trigger them? I need the 3 conditions to be met, but Smartsheet just will give the option "Or When" in the conditions,ā¦
-
When Smartsheet form is returned it contains all columns in sheet, not just ones I used in the form
I have a Smartsheet with about 80 columns. When I make a form based on this sheet I may only use 10 of them as fields. When I publish the form, it looks good with only 10 fields. Yet when I get the filled out form returned, all the columns get returned including the ones that were NOT used as part of the form. It is superā¦
-
Removing condition from conditional formatting rule
I can add multiple condition to a conditional formatting rule. I can modify those conditions later on. But I cannot find ways to delete the unneeded condition from the formatting rule.
-
Is there a limit to document builder mappings?
I am creating a database and I need the database to populate forms using the document builder function. Due to the nature of the data, each row requires its own mapping to because each form that is mapped is slightly different. I realize it would be best if each form was the same so I could use one mapping, but that's justā¦
-
SmartSheet Splash Screen
Hi I believe the answer is No but wanted to check. I have published a form that we would want to have our external customers to complete. Prior to showing the form, the SmartSheet Splash screen is shown then the form. Is there a way for the splash screen to be disabled?
-
Using the same column in more than one sheet.
I have one sheet created of active projects with columns such as project name and department.Ā I need to create another sheet that will have mostly different information but the project list and departments are the same (both are drop downs). Instead of recreating these columns, can I reference these columns in the newā¦
-
How to delete rows automatically
Community; I manage a process that injects a fairly high volume of rows into a sheet at least weekly. These rows are meant to be viewed by a sales team, annotated, acted on, and then archived. After about a month they lose all value (key data points are moved into our ERP or POS backend, depending on outcomes). But theā¦
