-
How do I report cost changes?
Hello, I am trying to create a chart that shows the financial impact on a community when a change is made. Here's the backstory - I am in homebuilding and any time there is a change at a community, we associate that change with a CRF #. I would like to be able to create something that shows the change in dollar amounts per…
-
Publish new workload schedule for dashboard?
First, I'm loving the new workload schedule in core Smartsheet! We do not own Resource Management (and it's not on the roadmap to own) and have been managing multiple sheets (one for projects, one for assignments) to track workload. While there is still a way to go, it's a good start (I do still miss the old core resource…
-
Allow embedding or linking to workload schedule in core SS
First, I'm loving the new workload schedule in core Smartsheet! We do not own Resource Management (and it's not on the roadmap to own) and have been managing multiple sheets (one for projects, one for assignments) to track workload. While there is still a way to go, it's a good start (I do still miss the old core resource…
-
Why am I getting an error with Bridge when I try to pull a list of sheets within a Workspace?
I am trying to build out a workflow in Bridge that uses an API to make a call to the workspace and pull all of the sheets within that workspace. I am using bridge with the correct account that has owner access to the workspace and I have the correct authorization key put int he correct form parameters. The workspace I am…
-
Can I send an update with the Full Form with Field Labels and Help Text
Good Morning, I have a Smartsheet set up with some pre-populated fields (i.e. Group Name, Ground Contact, etc.). I created a form to capture additional details for this group. I have an automation to send an Update Request to the Contact, with the pre-populated fields and requests for additional fields to be updated.…
-
Countifs(OR
All parts of this works on its own, but cant figure out how to make them work together. =IF($Help$1 > April$1, COUNTIFS({888 - Job Progress Slab}, <=DATE([Help Lot Size]1, April1, 31), {888 - Job Progress Final CO}, ="", {888 - Job Progress Origination Note}, ="Spec", COUNTIF({888 - Job Progress Final CO}, OR(@cell >=…
-
Can I create an email notification to be sent 2 weeks after a task has been created?
I am very new to Smartsheet and created a sheet to manage tasks, I would like to be notified 2 weeks after a task is created to follow back up on it, if it hasn't been resolved. Is there a way to do this? One of my columns is a date that the task was created.
-
Card view on mobile app of reports.
We have built a production log that gets regular status updates throughout the production process. The main sheet where all data is entered is not available to the majority of our users as there is some sensitive information in there. We have created a report that shows them only the columns needed for the production…
-
report not showing all columns from a sheet
I am trying to select a column to be displayed in my report that is on my source sheet but it isn't an option. The column I would like to display is circled in red below. When I search for it on my report it does not come up as an option: Anyone know why I can't display the column in my report?
-
Remove Attachments & Comments from Report on Dashboard
How do I remove attachments and comments from a report being displayed on a dashboard that has viewers from outside of my department?