-
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…
-
Automatic refresh after another person makes change in sheet?
Hello all, It seems that a sheet will automatically refresh after a fixed period of time, assuming you have no unsaved changes, when someone else has made a change to the same sheet. It'll give you a pop-up message and then display the refresh icon next to the sheet title. Does this happen after a specific period of time?…
-
Merged: Desktop App - Column Prop / Drop-downs Blurry!
This discussion has been merged.
-
Automatically capturing the name/ user who completed a form
I have created a form that needs to capture who filled it out. Currently I am having the person fill in their name. I am wondering if there is a way in forms to have the person automatically capture? That way they don't need to fill that in.
