-
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…
-
Hide or reveal a web form question based on answer from previous field
Is there a way to hide or reveal a question/text input field in a web form based on the answer from the previous question? For example, I am creating daily truck check forms for our paramedics and one question is "how many back rafts are there?". The dropdown list choices for them are "3", "Restocked", "Ordered" and…
-
Duplicate Values Conditional Formatting
Is it possible to highlight duplicate values in a column, as it is in Excel?
-
formula or workaround...
Hello, I'm trying to build a sheet to use for our onboarding process. It would be nice to have on sheet for all positions. The issue is that all positions do not require the same onboarding activities. I would like to reference the job title / column and have conditions that would have the sheet only display or include the…
-
Looking for a way to associate a checkbox in one field with content in another.
I am creating a log of all new, won opportunities. The goal is to catalog the types of services included in each new opportunity. Next, we need to understand the revenue split by service types. I created a web form that allows users to "check" the service types in the opportunity. Next, I need them to allocate the revenue…
-
Help Us Improve Smartsheet - 2 minute survey
Hello all, My name is Jeilymar Brady and I am the User Experience Coordinator with Smartsheet UX Research. Please fill out this survey, should take about 2 minutes: http://www.surveygizmo.com/s3/3515357/SmartsheetSurvey This is a quick survey we would love for you to take so we can gather some insights that will help us…
-
Conditional Formatting on Linked Sheet
Hi Guys I have a sheet that is a programme sheet which holds all the high level data of each project within the programme of work. I have a cell called budget variance which I want to be formatted as filled red, large bold text across the whole line. I want this to occur when the variance data is more than £9999. Currently…