-
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?
-
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.
