-
COUNTIF AND for data in 2 columns
I have 5 different locations and 10 different types of devices in 2 different columns of my spreadsheet. I need get a couple of devices in each of the different locations (i.e. I have 40 various devices in 5 locations - I need to know how many of each device is in each location). That's an example, there are actually…
-
Alerts when X ammounts of items arrive for project X
Backround: I work with custom computers, its only me myself and i in my department so i am looking to automate as much as possible. I have a sheet where i enter every part that arrives and which Project number it belongs to, what Serial number the part has and the parts EAN code. Goal: I would love if i could set up a…
-
Blueprint Automation Project Naming issue?
Dear Community, Every time i use a control center automation to get a project created with the configuration of letting user select or create workspace, control center is creating project with the title "[blank naming tags]" If i use the same blueprint with the configuration of use existing workspace or create new…
-
How to show # Days Overdue only if the task is not complete
Hello Community, So I have a sheet with different columns I am using three columns % Complete, End Date and # Days Overdue I want the # Days Overdue Column to show the number of days the task is overdue only if the task is not complete i.e. the % is less than 100% The current formula I am using is =IF([% Complete]@row =…
-
Missing Data on Metric Widget During a Dashboard Global Update
Hello, I recently ran a global update on a dashboard in a child blueprint and found all existing projects now show a "missing data" in a metric widget. New provisioned projects do not have this issue. The metric is pulled from a sheet cell that is part of the project blueprint. The source sheet has not been renamed or…
-
Errorcode: 1008, message: Unable to parse request.
Objective: Adding a row on smartsheet from ERP NetSuite (Uses javascript). The payload generated by NetSuite works perfectly via postman ! URL: https://api.smartsheet.com/2.0/sheets/xxxxxxxxxxxxxxxx/rows?accessApiLevel=0&allowPartialSuccess=false&overrideValidation=false Header:…
-
Formula to add X years onto a date?
Hi, I have a formula that adds 1, 2 or 3 years onto a date but the return date is going to the 1st of the month. Can someone please advise how to fix this so the date is exactly 1, 2 or 3 years later? Formula I have used in Next Review Date column =DATE(YEAR([Last Reviewed Date]@row) + [Review Frequency]@row, MONTH([Last…
-
Treten Sie mit anderen Teilnehmern der ENGAGE London 2024 in Kontakt
Guten Tag, ganz gleich, ob Sie im Mai zum ersten Mal auf der ENGAGE in London sein werden oder ein erfahrener Teilnehmer sind: Bitte hinterlassen Sie uns nachfolgend einen Kommentar. Knüpfen Sie Kontakte zu anderen Teilnehmern und teilen Sie mit, worauf Sie sich am meisten freuen. Die ENGAGE London 2024 findet vom 14. bis…
-
Proofing Column Auto-updating
Hi: I've just started using proofs and I have the columns added to my sheet including the "pending approval from" column. When I sent the proof out, I can clearly see the names of the invited individuals there, but when I added a new individual today, using the proofing panel to invite them, the "pending approval from"…