-
Suggestion for returning data based on selected criteria
I'm looking for some guidance. I would like a cell to return text (category) based on selected criteria (sub category) -- screen shots below. Example: If I select 'Wine' from the drop down, I would like the Category cell to return 'Food & Bev'. I could do an IF statement, however, there are several subcategories in the…
-
Having trouble with the move function
I've added a column with a simple formula to check a box when a column clears itself of an error =IF(ISERROR([Written number Ref]7), 0, 1) - woks fine no problem, the box gets checked when it is supposed to Once the box is checked I want to use the move function to move the row to a different sheet, however no luck there -…
-
How to create reports in a Legacy Individual Plan ( Pre February 1st 2019)
Hello everyone, I tried to contact support but I got no answer, so I'll try to ask for help here: I'm trying to create reports. On the "plans & prices" page it appears that with an "individual plan" there is the possibility of creating up to 5 reports, but when I do try the option is greyed out. By doing a little research…
-
Dashboard widgets are out of order in Mobile View
I've created an optimal layout for my dashboard in desktop view, but when I open the dashboard on a mobile device, the content seems to be all out of order. Is there a way to fix this? E.g. assign multiple shortcut widgets to a particular Title widget?
-
Can you select columns when the "copy rows" workflow is triggered?
Hello! I have two sheets for contracts. On the first one people will submit a contract via Smartsheet forms and with the copy rows workflow, the information entered will go to my master contract sheet. Everything works perfectly fine, the only problem is that the form people use to submit new contracts contains a lot of…
-
[help] Using SUMIF formula to calculate the sum of a column if between certain dates
Hey y'all! Here's what I have so far: =SUMIF({GRAD Student - Support Request Range Complete Date}, AND(<=DATE(2019, 5, 9), >=DATE(2019, 1, 7)), {GRAD Student - Support Request Time Spent Range}) Complete Date = the date range I'm trying to pull from After the "And"= The range I want for the dates. Time Spent = The location…
-
Using Modified Date in a formula returns #date Expected
Hello, I am trying to determine whether or not a row should be added to a weekly report by trying use the modified system column to calculate the associated Friday. e.g. It's Tuesday and I make a change, I want my other column 'Report week end date' to display that upcoming Friday. =IF(WEEKDAY(Modified@row) < 6,…
-
When creating/using forms, is there a way to have the formatting of a entry pull over to the form?
I am looking for a way to enter a list into a form and have it pulled into the sheet "stacked" instead of run together.
-
Linked cells not showing in dashboard report
I have a dashboard that surfaces a report in which the duration value cells is blank. The report source data is in a row report. The duration value is visible in the row report. The source the duration value is a sheet in which it is also visible. I have refreshed the report but as the duration is automatic I cant do much…
-
Reporting Question: create a report that aggregates Column information
Hi, I am trying to create a report that aggregates Column information based on a Condition. For example I have the following columns: -Track -Track Status -Days I would like to know a roll-up of the status by Track and then use days as a filter criteria. So if the days are 30, it would show status for just those that are…
