-
Adding Multiple Criteria + Does Not Include
Hello, Smartsheet community! I am stumped on a function. I have attached a photo of a dummy sheet with the same functionality I am trying to achieve. Using the example, how would I set up a formula which adds together the lunch selections of turkey, ham, and roast beef if they DID NOT choose soda as their drink? Lunch…
-
How to get JOIN working when referencing another sheet?
I'm using the JOIN formula, if I put the formula on the same sheet as my column references, it works just fine, however when I move this to a separate sheet and update the column references to the other sheet I get the error #UNPARSEABLE. I haven't removed any of the formula delimiters only which sheet I'm referencing. Any…
-
Copying Column Into Blank Sheet
I'm looking for a way to copy a single column into a blank sheet. When I started the project, I assumed cell link would be perfect, but that doesn't work with the destination sheet being blank. The project I'm working on uses a form that's filled out 24 hours a day. The information from the source sheet is copied into the…
-
Conditional Formatting To Red out a Row, if ID# has been used before
Hi all, I am trying to create a conditional formatting to mark a row Red if the ID# has been used before. I have plenty of conditional formatting experience however I just can't seem to figure this part out. Basically in a list of projects I.e 1,2,3,4,5 they move at different speeds and sometimes a project wont be on a…
-
New! View your reports in card view.
Hi Community, We're happy to announce that you can use card view in not just your sheets, but also your reports. Card view gives you quick and actionable insight into the status of work across all your projects by visualizing tasks as cards that can be dragged and dropped across lanes. Now, with card view in reports, you…
-
Is there a formula or other way to have a column display the date that a checkbox was checked?
Is There A Formula or Other Way to have a column display the date that a checkbox was checked? I'm also wondering if the user who checked the box could also be displayed in a column?
-
End User - Features locked down?
New to Smart Sheet, been using it for roughly 2 months as an end user. I want to like this app and not sure if it's the app itself or if the PM has locked it down so much that it is unusable. First, I can't sort on a "% Complete" column to know what tasks are complete and which need work on (this is on a filter that the PM…
-
I am trying to manipulate my SUMIFs Formula
When Using SUMIFS(Range, Criterion Range 1,Criterion...) I have multiple columns for example Estimate Spend, 25% spend, 50% spend, Rather than having multiple %'s of spend I just want to be able to use 1 reference and multiply it by 0.25 or 0.5 in the first "Range" category so =SUMIFS({Spend} * 0.25, {Phase}, "phase 1",…
-
How to populate unique identifier created through form submission on one sheet to other sheets?
Apologies if I'm repeating a question but I have not seen an answer. We have a Master sheet that users are inputting data through forms. Included is an auto generated unique identifier. We are also using the workflow automation to copy the entire row to separate sheets based on conditions. How can we populate specific…
-
New form builder with conditional logic now available!
Hello Community, I’m the forms product manager at Smartsheet and am pleased to let you know that we have launched a new version of our form builder that includes conditional logic. The new, full-screen form builder keeps more of the settings at your fingertips to help save time and reduce the number of clicks. You can now…