-
Sharing Permission levels for non licenced users?
Hi, Where do I need to find permission levels for non licenced users??
-
Dynamically Add Cell Data in the COMMENTS and Attachments or Anywhere
Does anyone know of a way to get cell information embedded into a row-level comment? Without copy-paste. The double-handlebar feature is amazing when creating workflows and I was wondering if the feature is available in other parts of SmartSheet. Attached are screenshots which displays the concept. I submitted a feature…
-
Sumif with a date range
I am trying to calculate the billing amount for an individual month when there are multiple months in the column. Below will calculate all of the billing, but I want to call out 11/2020, 12/2020, 1/2021. What can I add? =SUMIF({Monthly Detail Range 1}, [Primary Column]@row, {Monthly Detail Range 2})
-
Comments in report widget
Hello, I have a dashboard upon which I am displaying a report using the report viewer widget. However, I am unable to select the "Comments" column as on of the columns to appear on the widget. Our team members post status updates and actions to the "Comments" for each item on this sheet, in addition to the "Status" column.…
-
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?
