-
Query String to populate form
I have a query string I am using to auto-populate a form. It works great until the cell has multiple values. Here is the query string: ="https://app.smartsheet.com/b/form/611a48e1b24d445eb48e373c9e06e1fd?Internal%20Course=" + SUBSTITUTE([Course Name]@row, " ", "%20") + "&Course%20Start%20Date=" + SUBSTITUTE(Date@row, " ",…
-
Salary Formula ( Calculation of Basic and commission)
Hi , I need formula for (Net Salary) col as follow : To Count the sum in Col (Basic Salary) Plus sum of 15% for amounts equal/less than 600 and sum of 25% for amounts more than 600) of the number in Col (Total Income) We Pay our Employee (ex. sales man) salary with compensation of basic salary PLUS markup commission as…
-
Calculation Formula /commission calculation
Hi , Please find attached I Need to create formula in Commission column as follow : If amount in Price Col has amount equal to 20.00 or less Than to input the amount 2.00 in commission col and if the amount is between 21.00 to 25.00 than to input amount 3.00 in commission col and if amount is between 26.00 to 30.00 than to…
-
Health Formula
I'm currently trying to create a formula that will allow me to update the health status of tasks using both the due date data and the status of the work. I've tried looking at other discussion forums, but using those formulas does not seem to be working for me as they are causing errors. Is there anyone out there that's…
-
SUMIFS and CONTAINS Formula
I am try to sum the total weight of a column on a different sheet if the name contains certain text and will be released on a certain date. I am using the below formula but getting #INCORRECT =SUMIFS({Estimated Weights Range EST Weight}, CONTAINS("C-Vibez", {Estimated Weights Strain Name}), {Estimated Weights Est Release…
-
How to use any date within a date range as formula criteria?
O, great wizards of the Smartsheet community, hoping you can help me cast a formula spell. Trying to create a formula to flag if a resource is overallocated in a master sheet that tracks resources across multiple projects. NOT using either the legacy resource management or RM by SS, just core Sheet functionality. I managed…
-
Project status synchronization between 2 sheets
I have 2 sheets (2 project trackers) and need to present the status in a "master" tracker based on a data from the "slave" one. The problem is that in the slave there could be couple (even 20) rows that are connected to the one project in the master file. They are connected via Project Name column. I need to somehow merge…
-
Rolling Year Formula
I have a file that will be used to calculate 13 rolling periods for graphs and reports. The file contains 13 rows only for the number of months needed in the reports. I need a formula that will enter the year number in the "RollingYear" column. I have the formulas for the needed month number. The start calculating from the…
-
Formula not doing basic math correctly
im trying to build a metric for a dashboard that finds the percent difference between the actual and the required amount. for some reason going =[Required Capacity]@row / [Actual capacity]@row gives a different answer than =140.5/145.3
-
FILTER function
Is there an equivalent of the FILTER function in Excel? =FILTER (array, include, [if_empty])
