Hi everyone! My name is Alex (Brucey) I work in the Renewables industry in the role of operations manager. I work for a company called Renewable Connections who are a renewables developer (solar and battery power, soon to be green hydrogen too!). We have recently had a large cohort of new starters and I am wanting to put…
Hey community, I have had an issue ongoing with Control Centre for 3 weeks now. The general helpdesk could not help and now the case has been escalated. They haven't turned up to the meeting and they have not put a contact number in their email. This is becoming very frustrating and it has already been disrupting work. Can…
Hi there I'm struggling to get the syntax for a COUNTIFS(DISTINCT formula. I am creating a check sheet which counts only unique references against an SPV name. I have a list of the SPV names and I only want the check sheet to count unique references from the data input sheet with unique references and that match the…
我添加了三个数据集通过全球乌利希期刊指南ates, the columns appeared in my summary sheet automatically as usual but the data itself isn't auto cell-linking like it has previously. I have made sure the column types are dates as all the data is a date. I have removed all column formulas from the summary sheet as requested. I…
Hey I'm trying to get a tickbox to show at checked if : The ticket ID matches from another sheet The tickbox is also checked in that same sheet =IF(AND({TicketID} = [Ticket ID]@row, {Completed} = true), true, false) I have also tried replacing true/ false with 1/0 Thanks!
Hi there, I am attempting to make a calculator in Smartsheet using formulas like TAN and ACOS. These work in Excel but not in Smartsheet. Does anyone know any work arounds?
Hi Team, Would we be able to have mathematical formulas like TAN and ACOS please? Anything similar to excel. Currently we have a calculator to get some figures but we have to export into excel and then import them back into smartsheets. Thanks,
Hi I'm getting the above error. I am attempting to add a new report from the template folder to all projects and it's not working. Most of my tests seem to be working great but when I run the global update I am getting this error. Full error : Error 1012 Required object attribute(s) are missing from your request: sheets,…