-
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…
-
Can a column be formatted for HH:MM entries?
I need like to track working hours in sheets so it would be helpful to format the columns as an hh:mm entry, is this possible? Thanks
-
Workflow to change a cell value isn't working properly (changing the values I input)
I have several workflows to auto-populate a required reading column value based on what procedure is being performed. Most of them work just fine, but a couple of them are changing when they auto-populate in the sheet. For example, I have the required reading for a specific task as "3941, 3987" but when the cell…