-
Fórmulas a la hora de crear automatizaciones y flujos de datos
Buenas tardes, Tengo un par de consultas acerca de las fórmulas a la hora de crear automatizaciones y flujos de datos.Por un lado, cuando se crea una automatización no he visto forma de que añada una fórmula en una celda, ya que si la creo como "Cambiar valor de celda" no lo aplica como fórmula, le añade un apóstrofe al…
-
If or Collect statement to bring back correct pricing
A vendor has given us a step price increase over the next 3 years. But I can't figure out the best formula to bring back the correct pricing. I have 13 sheets that will reference this sheet for pricing. In order for the pricing to generate for our use, I need it to be correct for the year. It's going to be complicated.…
-
I am trying to calculate benefit eligibility dates.
I need to calculate the 1st of the month following 60 days of employment. Ex. If a hire date is 1/15/2024, then I would need the formula to return 4/1/2024 (60 days after 1/15/24 is 3/15/24, so April 1st would be the date they are eligible for benefits).
-
Pause Time Tracked
I have a request to create a way to track a certain record's time since it's been opened, but the user would like the tracked time to not include when it's in a certain status. For example, if the record is in "Open" status for 2 hours, have 2 hours tracked. If the same record is changed to "Waiting on feedback", however…
-
How can I make COUNTIF into a column formula?
I have been using a COUNTIF formula that I am unable to convert to a column formula. Is there a way that I can alter it so it can be a column formula. This is what I have: And this is the message that pops up when I try to convert it to a column formula: I just don't want to continue to drag the formula down with each…
-
How can I make COUNTIF into a column formula?
I have been using a COUNTIF formula that I am unable to convert to a column formula. Is there a way that I can alter it so it can be a column formula? This is what I have: And this is the message that pops up when I try to convert it to a column formula: I like the current formula because it allows me to set up my Request…
-
How to average the duration between dates if conditions are met
I'm building a spreadsheet with monthly metrics and having issues creating a formula. There will be a separate smartsheet with individual events (1 row per event). The formula I'm trying to build: For all events with a date of notification within X month & year, average duration between 2 dates (start & end date for each…
-
Trying to calculate Service Mileage interval to trigger update request and reset counter
Hello everyone. I'm trying to build a solution to manage our fleet of equipment. One of the things I need to track/manage is mileage and when certain maintenance tasks should be done. We have the task grouped into A (7000 miles), B (14000 mile) and C (40000 miles). Our technicians will be performing a daily check of the…
-
Is there a way to weight a report based on a value?
We track tasks with smartsheets and we have an effort level column that is meant to help demonstrate (via a report) what workload across a department looks like. We want to be able to create a report that weights projects with a '1 effort level' smaller than a '4 effort level'. Any suggestions on how we could do this?
-
Time Spent /Formula
Hello, I want to calculate the total time spent by each user to then create a graph. I tried a formula but it does not work. Can you help?