-
Forms Workaround: Submit button opens new form to allow sub-info - How do I stop when user is done?
Please help! I'm stuck. Goal: Create a form customers can use to report a problem with an order. The order may have more than one line item (i.e. Customer ordered 5 received 3 of product #1-ABC and ordered 3 and received 5 of product #1-ABE, both on same order) I want the customer to be able to provide their contact…
-
Unparseable Error
Good morning, I'm new to Smartsheet. I'm getting an error when I add the following formula. I'm trying to get it to return the current project phase that is less than 100%. Do you know what I'm doing wrong? =IF([% Complete]37<100%,[Task Name]37, [% Complete]54<100%,[Task Name]54, [% Complete]75<100%, [Task Name]75, [%…
-
What formulas to use in a timesheet solution to SUM up values
Hello, I have used one of the great solutions that has been posted by, I believe, @Paul Newcome relating to tracking and working out time/duration of hours in a HH:MM format. There are 2 columns to achieve this - the first uses a formula to work out the numerical duration: =((VALUE(LEFT([End Time]@row, FIND(":", [End…
-
Between Dates Formula Referencing Another Sheet
I have two sheets I am trying to tie together. Here is the scenario: Sheet 1 (Below): Has the city reference. Current Rent is where I am trying to type the formula. Idea is to return the current rent based on today's date and the city. Sheet 2 (Below): Has the rent schedule range and the city to reference. There will be…
-
Calendar Display Column
How can I change which column is displayed on my calendar?
-
How to make a COUNTIFS Formula work
Hello, I'm hoping someone might be able to help me make a COUNTIFS formula work. Some background... I've set up a sheet that aims to capture a team's availability of staff in any given month, should their be a major event occur. The staff would complete a form that asks for their name, contact details, job role and their…
-
Modified report based on when comments were added
I am trying to figure out if it is possible to either create a report or even have the modified column updated based on when a comment/attachment was added. Right now, the modified default only updates when someone updates a cell in the row itself. Please let me know if you know a way around this. Thanks!
-
Search rows API after create rows API from Power Automate/Flow returns incorrect row object ID's
I'm attempting to have a flow in Microsoft Power Automate/Flow create rows in a Smartsheet sheet and update a field once an approval outcome is present. The first part works with no problem - rows are created with a value in one column to help identify (e.g., SR001) - but after they're created, querying the sheet for all…
-
Find the Percentage of the Total
Hi! I have 4 columns that I have added together in the 5th, Total column (using =sum formula). Each of the 4 columns is a single dropdown select (values: 1-10). I want to translate the Total into a percent in the Percentage column, so I thought if I took the total value and divided by 40 (the max amount) in the % column, I…