-
Multiple Sheets & Formula Updates
I am using Smart Sheets for Paid Search requests. So, when an AE submits a request for their client, we ask them for specific URLs to be entered. In the sheet where they enter in their URLs (via an Update Request), there are some formulas (vlookups) that we use. For the most part, those work fine, but there are times when…
-
A sheet with links to all my SmartSheet Objects
I am looking for a way to inventory all the SmartSheet objects I am associated with Columns may be Object Type- Sheet, Report, Dashboard, Dynamic View, etc Object Name Workspace My role- Owner, Admin, Editor. etc Link to object
-
is it possible to list in the sheet the date of updating the sheet automatically?
is it possible to list in the sheet the date of updating the sheet automatically, is there any formula for it?
-
How can use the Countifs function with the Today function in the formula?
Hello, I am not sure what I did wrong in the formula that I have created. When I physically count it, I would get 23 but the formula spits out zero. I want the formula to report the number of tasks that was within the last 30 days. Here is my formula: =COUNTIF({Ready For Upload Range 4}, {Ready For Upload Range 2} <=…
-
Emailing a row from sheets does not show who is cc'd for recipient
Hi All, Something has changed recently in this process, it used to be that if I sent a row to Andy, Bob & Dan - everyone would be cc'd on the email received & when anyone responds, everyone gets a copy - and a group conversation occurs. Now, when we send a row to Andy, Bob & Dan, the recipient does not see that anyone else…
-
5x5 Risk management formula
Can anyone figure out what's missing in this formula to set a rating from a 5x5 risk matrix. I copied the format from the risk assessment matrix template set that is a 4x3 matrix and modified. =IF(AND(OR(Likelihood5 = "Rare", Likelihood5 = "Unlikely", Likelihood5 = "Possible", Likelihood5 = "Likely"), Consequence5 =…
-
Is it possible to have a report that is editable by people who dont have access to the source sheet?
Within the company I work for we have a source sheet with all our projects in. We need to be able to enable external (sub contractors) people to sign a report which auto fills information into the source sheet. (check boxes) This is so we have an audit history of them accepting projects. However, we not not want them to be…
-
Tracking date when a drop down value is selected
I'm creating a project tracker where I can assign what phase the project is at (design, prototype and complete). What I want to do is track how long the project is in each phase, so what I plan on doing is tracking when the drop down items are changed. I thought of using an IF statement where if "design" is selected, then…
-
Gathering data from 1000 sheets
Hello, i have this question: We have more then 1000 sheets with some project progress calculated in certain cell. Then we have one master tracking sheet with 1 line = 1 project. What i need is: Link this progress number from each sheet to every corresponding line Use that number for further calculations (which is not a…
