-
Reporting
Newbie question so please bear with me! As previously discussed, we use 3 columns to calculate the % Complete (which we then have to manually enter into the standard '% Complete' column), which are: Planned Effort Actual Effort Remaining Effort What I need to be able to do is to create a Summary Report based on the three…
-
Approval Request with Multiple Conditions only Sending First Request
I need an approval request to run to any impacted team leads when a new estimate is uploaded. For example, if a new estimate is uploaded and the departments included are Search, Social and SEO, I need an approval from the lead of each of those departments. I have an automation set up for approvals that is triggered when a…
-
Is there a simpler way...
...to do the following: At the beginning of every month, take the values from a sheet and copy them to another. Essentially, take a "snapshot" of the data in dynamic fields, and store it in another place. Details... 1) The values I want to take are in a Sheet Summary. Since those can't be linked to (correct?), I needed to…
-
Creating a community forum through smart sheet
Hi everyone, I'm pretty new to smart sheet and was wondering if Smartsheet is able to be used to develop a type of community forum / discussion board within smart sheets? Like could we develop something similar to this Smart sheet Community and have it accessible through a portal? If you have any helpful resources, that…
-
How to keep the sort order of grid view in card view
Hello, I have a need to sort two columns, both ascending (works in Grid View) but that sort order is not staying for every column when I switch to card view. The business goal is to sort by workstation, then by the priority of work order in the queue for the work station, so each station knows what to work on next (Work…
-
Form is not populating to Smartsheet - Help!
Hi there, Created a Form and tested successfully last week, data entered into Form after submission populated properly to Smartsheet. This week, 'live', form info when submitted is not (making it to) populating data to Smartsheet. Any idea why this is happening? Thanks!
-
Workflow Copying - Entire Columns
Hello Experts, I am writing a workflow to copy and paste a particular Column value from 1 sheet to another sheet. However, the workflow is copying the entire column details from the spreadsheet.
-
Sorting Unlocked Rows or banging my head against the keyboard!
i have a a sheet. no columns are locked. I have a "Date Changes Made" column that i wish to sort in date order example every entry from 7/1, 7/2,7/ 3 etc so that I can have all dates of the current month together. My list is a running list so it contains dates from April-July so far. When I have used the Sort rows…
-
Cell Linking - Doesn't Work Consistently
Hello, I am trying to pull a column data from a different sheet using CELL LINKING option. However, when there is a data change, CELL LINKING doesn't bring the new data. Note : I am using Data Uploader to retrieve the data with REPLACE option
-
If I would like to share a Gantt view sheet with non users for a meeting can I just provide URL?
If I would like to share a Gantt view sheet with non users for a meeting can I just provide URL? Or do they have to become SS users and I have to add them as viewer access to the sheet?
