-
Auto Lock columns or rows through formula
I want to know if it's possible to create a conditional formula (or something like that) that as a result Lock the row or the column. When the user's filled the entire row I want to lock it from other changes, automatically.
-
Why smartsheet require login for published sheet?
Previous embed the smartsheet in the wiki by iFrame, which is published link , it doesn't require log in. But now it required log in, it is really annoy. Any way back to original way?
-
Sheet Summary cell reference changing?
Hello, I have built a sheet summary with formulas that look something like this, =COUNTIF(Provider1:Provider154, "Syringa"). The problem that keeps happening is that the cells I referenced to count, are changing randomly. For example, I will reopen the sheet and the formula looks like this, =COUNTIF(Provider24:Provider75,…
-
Dropdown Form Entry
I want users to enter data via form and one of the fields is a dropdown list and I do not have the restrict list to values selected. I want people to be able to submit new entries via the form but it will not accept any that are not already pre-defined in the dropdown list. This seems like a defect to me. People can add…
-
Function Help - Sheet References
Hi there - I am working on building a slightly better project tracker for our organization. We currently utilize calculated fields that we have to define for each new project, and sometimes the project does not have enough project rows to account for all items we are tracking. I need help with a specific formula that would…
-
Smartsheet Policy for your Company?
Has anyone written a Policy & Procedure for your company for rules around using Smartsheet? I'm working on one now and don't want to reinvent the wheel (If anyone is willing to share) - and would take any suggestions of anything you recommend I include in our policy. Off the top of my head, I'm thinking we need to cover: *…
-
Manage Azure AD users in Smartsheet
Hi, Currently we have a Business Plan Suite, is there a way to manage our Azure AD users in Smartsheet? For example, We have our personal info filled in in Azure AD, how can I import this into Smartsheet? Thanks in advance.
-
Dynamic View: Give access for requestors via their email address
Hi Community, we are using Status View at the moment to share the actual status of IT requests (Demands) to the requestors of different department. The access is given to the requestor via their email address they have to maintain while handing in the request and then they have to login in to status view with this email…
-
How Nested IF can I get?
I have a desire to change a Status column based on whether (or not) certain separate (other) columns are populated with a date. Is this supposed to work? All of the Nested IF examples I have seen tend to look at just a single column to evaluate against, and I'm wondering if I'm going to be able to make this work, and using…
-
Automated Workflow - Invalid Date Error
I have set up an automated workflow to trigger when status changes to complete if date field is greater than 12/31/18. I am able to choose the date but it changes to "Invalid date" when i save the workflow. I thought maybe since the date field i was using is an automatic number field, it didn't recognize the field as a…
