-
Web Forms
Hi Is it possible to have additional lines appear conditional on a specific answer (tickbox checked) I'd like 3 additional questions if the box is ticked. If not then I can add the questions, but will add 150 lines to my Web Form and makes it rather long.
-
Relationship between the "Status" column and other columns
I'm relatively new to Smartsheet, but it seems strange that the Status column appears not to have any relationship to other columns in the project sheet. But maybe it's possible to use a formula somehow to do that? Some specific questions: * If I change a task from Not Started to In Progress, can I set up Smartsheet to…
-
Conditional Funding
Would there be a way for me to add my second and third columns based upon the conditional formatting of the rows? the conditional funding only depends upon one variable.
-
Conditional Formatting or Formula?
s it possible to create a formula or a conditional formatting rule that would automatically highlight any child rows as they are created and/or based on a specific term or text in a column of the parent row?
-
Web form phone contact filling by customer missing number can it set formatting?
Web form phone contact filling by customer missing number can it set formatting? Due to our client typing through the form by themselves some time we can't control what they type. At this stage, for my case I just wonder is there a way to set the format condition to make the fill in data from this example Phone…
-
Turn hours (hh:mm) to numeric value (00.00)
Is there a formula to make a column with duration values like 1:30, 2:45, 3:15, etc etc (only ending in either :00, :15, :30, and :45) to 1.5, 2.75, 3.25 hours (again, only ending in .00, .25, .50, and .75, respectively)??? I am VERY new to SmartSheet so, if you could actually explain how to do stuff that would be awesome.…
-
Allocations
Scenario 1 I have a task that happens every Tuesday but only takes 1hr of my time. I don’t want to create multiple rows to indicate this as one 1hr of the day, is there another way to do this? Scenario 2 I have task that happens with a span of 5 days but only takes 3 hrs how do i calculate that? Is there a way to do this?
-
Grid
Good afternoon , I would like to take off from the first few lines from my sheet the grid not from the total sheet only from the top is their to do that . if so i can make my sheets into a nice looking invoice now i download it into excel and do it from there any ideas ?
-
Can smartsheet do this
I'm new here but have watched multiple webinars and read the getting started info. Before I invest a lot of time in this, I'm wondering if smartsheet has the ability to link two sheets with a one-to-many relationship. For my purposes, I'd like to have one sheet of open orders and another sheet of lineitems. There can be…
-
Feature Request - Auto format for ranges
It would be extremely convenient if we could set our autoformatting rules for a Row, a range, or even the whole sheet, instead of just one column at a time as is the current configuration. EXAMPLE: I have 15 columns that I would like to apply the same 6 formatting rules to. Currently, that means that I have to define 90…
