-
Can you make a field required on a sheet?
Hello, We use a sheet for our HR departments. We want to have a field required to be filled out based on a drop-down menu selected. So if the status of the drop-down is HIRED, they should need to fill out who the direct Report is, so the data is complete. This is not on the form. This is directly on the sheet. Thanks in…
-
Calendar App error showing separate 'color code by' values for the same user on Assigned to field
We have a calendar in the Calendar app that is pulling from a roll-up task report for all of our projects. We have the color coding by Assigned to, but this is resulting in split values for some users - one showing their name and one showing their email. I've checked all of the tasks for these users and all are using the…
-
Is it possible to make a work flow app
Hello, I am wondering if it is possible to create a workflow app that takes data from my sheet, and based on the value of one cell in a column, makes that row visible to another user so they know they need to complete that rows "job", and then with a click of a button on their part, mark it as complete, and it then moves…
-
Workflow actions not being triggered by changing linked cell
I currently have 2 sheets, sheet 2 has dates cell-linked from sheet 1. In sheet 2 I wanted to use the "Change Cell Value" action whenever the linked date changes in the sheet to save "Yes" in a column called Date Change. However I see that even when the date changes the workflow is not being triggered. I have read that…
-
Adding more rows or columns
Hello, I have 25 rows for different initiatives. Each initiative is shared with multiple depts (up to 10), and each dept needs to document a few outcomes for their initiative. In your experience, shall I add 10 depts X 3 outcomes so 30 columns to each row? or copy the initiative into 10 rows and assign one dept per each…
-
Can anyone explain why my series labels suddenly changed to white?
Not the most intuitive change, and I can't seem to change it back. Somewhere in the last week this was changed?
-
Forms logic
I want to have 2 conditions of logic in order to show a field. For example, if an order payment is covered and there is no charge, show the approver field and select an approver. If an order is covered and there is no charge, and it needs to be rushed show the rush approver field and select a rush approver. If the customer…
-
Data Security and Risk Management
I would like to know more about data security in Smartsheet. Does Smartsheet has appropriate third-party security assessment. For example, regular vulnerability or penetration tests of your data centre and systems?
-
Mobile view with Smartsheet App
Hi everyone, I have a question about the mobile view option when you use the app. Do you have explaination about this function ? Maybe in Smartsheet University? Because I don't know what I can make with and all functions of this view. Thanks
-
created date functionality more than once in the sheet
I would like to have possibility to use created date function more than once in a sheet and have possibility to assign created date column not only to the whole row but also to columns chose by me, i.e. I would like to se when and what time somebody changed status of a task, what date and time somebody finished task. Would…
