-
Sheet ownership in the workplace
Summary : 2 questions. 1. Moving sheets in a workspace changes ownership - Why - can I stop this happening 2. Reporting in workspace does not appear to allow for additional sheets in a workspace folder to be updated to the report.?? When creating the report and the folder inside the workspace is selected it shows only the…
-
Appsheet timestamp date format
What is the trick to converting the app sheet timestamp date format to be recognised by smart sheet? On the face of it both look to be the same. timestamp format from within smartsheet is = 3/3/2018 11:48:41 timestamp format inputted from appsheet = 3/3/2018 11:48:41 I tried the DATEONLY() function on the app sheet date…
-
How do I change a user's login name
What is the correct process for changing a user's login name after they have a name change (marriage, incorrect spelling when created, etc) I see I can change the first name / last name, but I'm not able to find out how to change the login / email address.
-
IF formula to combine rows if checkbox checked
Is there a way to do this? I would like my Primary Column (Task Name) to combine it's text with my 'assigned to' column if the condition of the checkbox in column 'Show' is checked. thanks Mike
-
Formula Date Remaining Static
I have aprroximately 30 sheets related to a corporate merger. In every sheet I have a formula that populates today's date +1 whenever a status column value = Complete. The formula is: =IF(Status2 = "Complete", TODAY(1)) This then triggers a reminder to a supervisor to review the task and approve its completion. So, the…
-
one task through multiple calendars
I'll try to explain what I'd like to accomplish. My task name has sub-tasks for example "custom","boxcut", "assemble","finish" that populate calendars. On the calendars they show all of the "custom tasks" for all main jobs. How would I setup a calendar to show all the sub-tasks for just the selected task. Such as the…
-
RYG symbols and nest IF's
I'm new to the community and frankly new to Smartsheets... I'm building some RYG indictors to give a quick visual indicator when a task is at "risk".. my nest IF statement is set to track a task against TODAY() - Finish... ie the closer the Finish date comes to Today's date, the higher the risk. My challenge is the Green…
-
Expand All after applying filter doesn't work
We have a sheet that has a primary column of parent categories with about 20 child tasks under each. The problem we are experiencing is when we filter by another column, the parent / primary column won't expand to show ALL of the child tasks. Below is an example of Program Name (primary column) expanded. I want to FILTER…
-
Card Format - Report
I have built a report combining all my individual sheets to keep of ongoing tasks in one place. I want to be able to view this in Card View, but that doesn't appear as an option in the Toolbar. Is there something I can do?
-
Ruler - alignment tool
We are only 6 months into our Smartsheet journey and thus often tinkering and creating new reports, it would be really handy to have a ruler at the top in order to align fields/columns in reports. I have marked where a ruler could sit with highlighter yellow below. Does anyone else recognise the need or have an alternative…
