-
populate a field based on if a due date is x days or less.
anybody by chance know what is the easiest way it possible to set up a formula that reads a field to auto populate a date that is say 10 days before another date (due date)
-
Allow a cell to only be certain days of the month
I put together schedules that include public hearing dates that are typically certain days of the month , i.e. 2nd Tuesday, is there a way to assign this to a cell in my schedule? Currently I have to go to that point in my schedule and manually find the date and each time the schedule changes I have to make sure I update…
-
Hyperlink from Sheet clickable in Metric Widget on Dashboard
We are having people create a hyperlink in a cell on a sheet to a word document saved on our O365 sharepoint. I want this link to then be available on the dashboard. I currently have the cell linked in the Metric Wizard, but when viewing the dashboard, the link is broken and only the words are there. The users are not able…
-
Drop down list data from column in another sheet
Hello Users, I am very new to SS and was wondering how I might go about achieving the ability to link a cells data to an entire column in another sheet. For example, I have a "Current Jobs" sheet and a "Distributors" sheet. When I enter a new job in Current Jobs, the Distributor field in current jobs must only contain…
-
Automatically move item to different Smartsheet once completed?
I have a feeling that this solution doesn't exist within the current setup. Is it possible to move a row from one Smartsheet to another once the item is shown as completed? Thank you!
-
Where is referenced field
Ok, first, I took over this sheet, report, dashboard from a former employee and out of nowhere a sheet stopped working. I know the problem, just trying to determine how this happened and how I can fix it. There is a cell with a formula. The formula references a field in some other sheet. How can I determine where it is? If…
-
Consolidate Metrics from multiple existing and new sheets
Hey Everybody, We currently have multiple workspaces for each individual job that we do. Each job will have its own Metrics sheet that brings data from the other sheets for progress. As new jobs come in, new workspaces are created. I am looking for a way to be able to create a high level Metrics sheet that can look at all…
-
Nested If Statement or vlookup
I need some assistance with a formula, if possible, still fairly new here. We have two sheets that need linked together but I'm not sure to use an if statement or vlookup. Our Service Team orders parts through a form on the "Non-Stock" Smartsheet (they love it! compared to our old system) Shipping and Receiving records…
-
If with dropdown list
I'm trying to come up with the formula to dropdown only certain countries if chose certain region. I have two dropdown columns Region and Country If chose Region EMEA, country dropdown list will show DE, DK, NO If chose Region APAC, country dropdown list will show JP, SG, IN If chose Region AMER, country dropdown list will…
-
Free Collaborator / Unlicensed User
Hi, Just a small question is the Unlicensed User can also delete the row? Scenario: we have created a workspace and we want Unlicensed User to only edit the row but he/she can't delete the row. secondly: if Unlicensed User delete row or related information in row how the admin will get to know what happend or what is…