-
Move Row Data Automatically Within a Sheet
Hello, I have created a spreadsheet to track admission data into our facility. I used the TODAY and TODAY +1, etc.. function to show the correct date. I also used the IF(WEEKDAY) function to show the day of the week. What I am trying to do now is make it so the row information from those dates moves up automatically. Based…
-
Undoing a sort and reverting to a sort rows by date
Hi! We have a sheet with multiple editors. The first column is an auto generate "Created" column. One of the users sorted a different column and saved. When attempting to sort the created by column ascending so that it reverts to the rows being ordered in the sequential time order in which they were entered, it remains…
-
Dashboard - Select various sheets
Hello, I am wondering if it is possible to have a dashboard view with a dropdown for various sheets within a workspace. I have multiple different project budgets - all using the same templated budget form and Id like to create a single "Project Dashboard" where I can analyze the project-specific data upon selection from…
-
Using international date format in auto-generated notifications
Hello, I have created a workflow to notify the users that their issue will be resolved on a specific date. That date is stored in the SmartSheet in a column called "Resolve Date" . So, in the message I used {{Resolve Date}} to show this value. Problem is, it always shows the date in US date format (mm/dd/yy), although I…
-
Setting date based upon another date
Hi everyone, I am seeking help in setting a date column based upon another date column. Put simply, I have a "date received" column and a "created" column, where the created column populates automatically based upon the time a submission was made using a form. The "date received" column I have been manually setting, as any…
-
Parent Row Check Box Complete when all child rows are checked off
Good afternoon I am using this formula =IF(COUNT(CHILDREN(Scope1)) = COUNTIF(CHILDREN(), 1), 1, 0) to try and have the parent row checked off when all the children are checked off but it is coming up with this error, any ideas on what I could be doing wrong?
-
Merging two sheets into one
Hi, In Smartsheet can we merge two sheets into one sheet. EX: Sheet A and Sheet B, can we combine then and make sheet C. Could you please help with that. Thanks, Rakesh
-
Would like to pull information from another sheet
I have a main sheet, when I enter information in my primary column, I would like other columns to be auto populated with matching information from another worksheet. I have no idea how to make that happen.
-
How to add phases (or use sub projects)
In MS Project I often used subprojects and could easily reference them in one row of the WBS. So, I looked for instructions on how to do this and the most relevant hit suggested that "phases" be used. However, the help instructions are either wrong or I am not interpreting them correctly. The instructions say to add a…
-
Resource View
I tried creating a resource view that pulls in the resource allocation between multiple projects. The combined resource view is only showing the names from one of the projects, not from both projects that I have selected. Both projects have the % Allocated column and task owner column in the contact list format. The second…
