-
Update/Approval request after declined
Hello, I am using Smartsheet for budget requests. The alerts & actions are set to send an approval request when the requester submits the online budget request form. If the approver declines the request, an update request is sent to the original requester where the comments, attachments, dollar amount can be updated. How…
-
Auto populate score based on 6 different criteria zones.
Hello, I have been asked to build a scorecard that would automatically insert a numerical score (0-5) based on the input given. So for example, if a perfect score of 100 = 5; 90 - 99 = 4; 80 - 89 = 3; 70 - 79 = 2; 60 - 69 = 1; and 0 - 59 = 0, I would like to develop a formula that would automatically insert the correct…
-
Radar Charts
Hi, I think the graphs implemented last year were an excellent and needed set of features. I still however have to use PowerBI for some of our charts. This is problematic. Can we get Radar Charts into the Graph Types?
-
Automate a rent increase on certain date
I am trying to automate a rent increase on a certain date. I have a table with Tenant ID, Rent Increase Date, New Rent amount. I would like to reference this in another sheet, so that when the rent increase date arrives, it will return the new rent amount. I can use the Index and Match to pull in the amount, just needing…
-
How can I take a concatenated string and feed it into a form as an option?
Can't figure this out.. I have form with 4 fields in it. The user picks drop downs off of each of the 4 questions and saves the form. In the sheet, I have a 5th column that concatenates all of the 4 fields. (It basically builds a unique name for each of our customer audits) and looks like this.. 2019_Jun_Fab5_Skyworks…
-
Matching multiple values from multiple columns in linked sheet to fill cell with content from third
I have Two sheets, one that acts as a "Rate card", it is broken down into Job title / Location / Day rate and the second is a budget sheet. For Example, Rate Card Column 1 / Column 2 / Column 3 Project Manager / UK / £10 Project Manager / US / £20 Developer / UK / £11 Developer / US / £22 In my Budget sheet I have a…
-
Adding a new currency
Hey, My company is use to work with Central African Francs (XAF) as default currency. At the currency list in the spreedsheet, we do not have it. Does anyone know how to add a currency? Thanks in advance!
-
Formula to look across rows and columns in a table.
Hi there I need a formula that will look across rows and columns in a table. For example, I need the result for School District-B with 23 items. The result from the table below should populate with: $350 1-5 6-15 16-25 26-50 51-100 100-50000 School District-A $100 $200 $300 $400 $500 $600 School District-B $150 $250 $350…
-
Changing linked cells to point at a new sheet en masse
Hi I have a task list that has dates linked in from a separate calendar sheet. We have 12 calendars (1 per month) but only the 1 task list. Is there a way to change all the links in the task list to a new calendar sheet rather than one by one relinking each one? Thanks