- Ranking Formula
Hello all, I have a sheet with columns that look like this: Spot in Queue Case Number Case Prep Completed Case Completed 1 100 x 2 101 x 3 102 Essentially, what I would like to do is change the spot in the queue when the case is completed. For example, when I check off 'Case Completed' for case number 100, the spot in the…
- Automatic workflow not working
I am trying to set up a recurring date to be entered into the sheet using automatic workflow (photos enclosed) I want to be able to type in "blah blah blah" into the event name column and have it repeat every month on the the third sunday. What am I doing wrong?
- Record changes to only 1 cell
In a sheet where another user and I download files and mark them in different stages (proofed, processed, uploaded), is there a way to record who last modified a cell rather than a whole row? I'd like to have a cell automatically record who changed which phase. I know that I'm able to right-click a cell to see its history,…
- Can the selections from a dropdown multi-select question in a form be used to auto create columns?
If I have a question in a project intake form that allows for individuals to multi-select all of the rooms that will be a part of a project can I then in turn use those selections to automatically create columns in the worksheet that corresponds to the rooms that were selected? Thank you for taking the time and any…
- Programming with Smartsheets
Is there any way that I can use external programming to effect my Smartsheets. Is there an API that would let me right seperate programs to control my Smartsheets?
- Changing an auto-generated number in a cell
Hello, Is there a way to override, or edit, an auto-generated number? I have an intake project sheet that generates "Job #" as new requests come in from a form. Recently a 'new' request was submitted through our form, giving that request (or project) a new auto-generated "Job #". However, this request isn't actually new,…
- I need to use an IF / THEN formula to compare a cell from one column to a cell in another column
I could really use some help! Thank you in advance! My STATUS column has the following colored options available per cell: Red, Yellow, Green and Blue. I am looking to use the following IF / THEN statements: 1. In STATUS, if the DELIVERY DATE is within SEVEN (7) DAYS of the START DATE, the LIGHT is RED. Can the DELIVERY…
- Uncheck cell based on values in another sheet
Hi all, I have a workflow request. I am trying to get a checkbox to reset to unchecked based on a series of conditions in another sheet. The below screenshot is the first sheet in the workflow. In this example, the checkbox in the column “Needs Review” needs to be unchecked based on these conditions: 1. A Review Date (in…
- Can I get alert for update request in Microsoft teams? (not as a bot, but as in team's chat)
Hi All I am trying to send an update request via microsoft teams and I successfully set up a workflow. But, the problem is the link to update the request is only coming from a bot of smartsheet rather than into the team(group) created. Under group, it is giving just a message that this user made an update. Is there any way…
- Process flow that also includes daily task checklists
我的新内容。我开发了a comprehensive process flow for our recruiting process. It has the tasks to be done, start/completion dates, who they are assigned to, and other steps. But there is one thing I can't figure out. Within the process, there are certain action items that need to be done on a daily basis.…
