-
if /or argument
Sorry to bother with such a simple question, but what is the problem with this? =IF(OR([Average 6mths]7 * 1.5 > [Current Monthly Usage]7, [ Average 6mths]7 * 0.5 < [Current Monthly Usage]7), 1, 0) I am just trying to return 1 if between 50 and 150% and 0 of outside that range
-
User Stories
Is it possible to have user stories with the ability to share across a team in smartsheet? I'm looking for some functionality similar to Jira without having to leave smartsheet.
-
how to tie up % conclusion with actual date
Is there any way to generate a "temporal analysis of the evolution of % conclusion" on a project.? I would need a way which every time the update of a task occurred, the smartsheet fixed the actual date so at the end of that task I'll have the evolution timeline for that. Thanks,
-
Using a Form to enter multiple dates at once, rather than individually
We have developed a Smartsheet to track event support requests, and I have created a form for our clients to use for the reqeusts. Is it possible to use the calendar to enter multiple dates in one entry rather than having to refresh the form and enter a request for each individual date? Thanks! Javier
-
form within templates
I have a question with the configuration of a form inside the tool. I need to know how I display text fields according to a selected data from the drop-down list. That can be configured? Saludos,
-
Group Columns
Hello, I do not believe this function is currently available but I would like to add it as a feature request. It would be very helpful if you could group a set of coulmns in a sheet and easily hide/show . There are many instances of columns that are not needed often, but would like to have available to see when needed.…
-
Special formula help
Hi, I'm hoping smartsheet community can help me with an automatic formula. We have a column called "Priority Deal" this is a symbol selection of the stars, where we rate a specific land opportunity (empty/one/two/three/four/five) I'd like to create a formula when a specific star is selected, the column "Deadline Date" is…
-
Report view without access to underlying sheet
We are attempting to create a report view that is a subset of rows driven by a column flag. We have found that the report viewer will also have access to the underlying sheet with all of the details. Our goal it to provide a highlevel summary via the report and restrict access to the subtask details.
-
Uncategorized Column
I'm using the Card View as an intake workflow. Is there a way to rename the "Uncategorized" Column? When a new intake request is created via the form, I'd like the request to automatically go into a "New Request" column, not "Uncategorized". Thanks!
-
Inventory Sheet, moving data to/from Excel and SmartSheet
Hello all, While I have a lot of experience with Excel, I am new to Smartsheet. I've been given a project and I'm having difficulty finding a way to perform what I need in Smartsheet, and am looking for advice/help. Effectively, I have a master inventory list that is kept in Smartsheet of equipment we are configuring and…
