-
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…
-
Viewing Deliverable for Multiple Projects by Month - NOT in a Gantt : )
So...any creative ideas for how to achieve something similar to the attached image IN Smartsheet? We want to visual represent high level deliverables across multiple projects for the entire year by Month, however, NOT in a Gantt view and we want it as a 1-pager. Thoughts? Ideas?
-
IF Statement-If text is updated in my "Comments" within the last 5 days I want to return Yellow Sta
Looking for formula help. I have a comments column that I want to make sure is never more than 5 days old. If the comments field is updated with new or different information - I want to return a Yellow star to the Updated field or a date for which it was updated on. Is this possible? Thanks Molly Morton
-
Why am I only seeing system columns in Report Builder?
Hi, I am having an issue showing columns other than System Columns in the report builder. As you can see from the attached I have my sheet selected. What am I missing? I tried saving and going back in, but this did not fix this situation. Thanks, Paul
-
Using Project Management Templates
I'm using the PM templates and the templates utilize a section in the project plan that is called Project Information. It's handy b/c you can use this non-task related information in dashboards. What my issue is w/in the Finance section under Project Info - there is budgets and actuals. I am trying to utilize the children…
