-
How can I dynamically redirect a form submitter to different URLs based on their form input
Hi Community — I’m hoping someone has solved a use case similar to mine. I’m trying to use a single Smartsheet form to route different audiences to different external URLs immediately after submission. Here’s the exact workflow I’m trying to enable: Advisor (customer) lands on our product page Clicks a single CTA → opens a…
-
IF function in an INDEX formula
Hi - My below index formula works to capture the "2.0 Status" field; however, I am trying to incorporate an another piece to this formula that includes a job number. Not sure if its an IF or AND or additional INDEX function, but i want to pull this 2.0 status based on the "Project Kickoff Rec'd" line in the task AND for…
-
Zoom In
Please add a Zoom In feature! Excel (and the rest of Microsoft Office) has a bar at the bottom where you can zoom in or out. I am often sharing my screen on virtual calls to show people Smartsheets. If I am using a large monitor and they are using a small laptop screen, the image is condensed and the text is hard to read.…
-
Third option for Approval Workflows
I was wondering if there was any progress made toward enabling more than just two approval options? I would also like to include "Approve, Reject, Modify". And while the update requests work, I feel like these workarounds are unnecessary and tedious. If we could at least require certain fields be required to be answered in…
-
Formula to bring dependent values
Hello Experts, I need to return a formula with Yes or No based on a sequence of current status and the preceding steps needs to be covered. The sequence is applicable as below. Pending Dependencies (F) Not Started (F) Pre Set Up (F) Set Up (F) Smoke Test (F) Smoke Test Validation (F) Full Run (F) Full Run Validation (F)…
-
Update Report with new drop-down options
This is a multi-step question. I have a Client Data sheet. One of the columns is Household Name. I'd like to be able to report various metrics at the household level - as well as the individual person level of the Household. In the screenshot, you'll see the Household Name, the Owner First Name & Owner Last Name columns.…
-
Need Help Fixing Formula in a Timeline with Subtasks
I used this formula in the past and it worked, but I no longer want the cell to have an updated Status of "Complete" if all sub rows are marked "Complete" or "Not Applicable". I would like to change it to return a Status of "Complete" if ALL sub rows are "Complete" and a Status of "Not Applicable" if ALL sub rows are…
-
How do I get the resources from a sheet to flow to a Form?
Hello! I am trying to create an intake form for my team. I have an assigned to column on the sheet that allows me to assign based on our company directory. This does not show up in the associated Form, however. Is there a way from the Form view to allow users to select their name from the same LDAP query that the sheet…
-
入出金履歴管理の設計について
個人単位の入出金管理について、設計の相談です。 Aさん〜Gさんなど複数名の入出金を管理しており、
以下のような構成を考えています。 ・シート①：全員分の入出金履歴（1行＝1取引） https://app.smartsheet.com/b/publish?EQBCT=63bab2005ccb46e5922aac9efd9bf560 ・シート②：名簿（個人マスタ） → 名簿側で現在の残高（SUM）を確認できるようにしています。 ・レポート①：個別の入出金履歴 https://app.smartsheet.com/b/publish?EQBCT=f090df15bdae4df894da7fc4ae26dfa2…
-
Activity Log should reflect all changes made to a sheet (in detail) including Workflows
As of today, the activity log doesn't represent all of the activities undertaken on the sheet. For example, if a row hierarchy or conditional formatting has changed, columns formatted/hidden/unhidden or removed, it won't show up on the activity log in detail. This is difficult when we are trying to investigate the root…