-
RFI Automation
I'd like help with creating the most efficient and the most automated RFI "module" containing the least number of steps from start to finish. I'll paste a workflow here to give some insight. Thanks in advance for any suggestions and help.
-
Last 7 Days Formula
I am trying to calculate how many IT tickets have been moved to the status of "completed" within the last 7 days. The formula returns a value of 6 but when I use the filters on the report, it returns the correct value of 2. Can someone help me with the formula so it returns the correct value of 2? The formula I have is:…
-
Nested IF giving me an Unparseable error
I am trying to create buckets of product go-live dates using the Nested IF formula. When I only had 4 buckets, it worked perfectly. When I added 3 more buckets, I cannot get it to work. Here's the formula: =IF([Workdays to Go-Live Target]1 < 0, "Past Go-Live Target", IF ([Workdays to Go-Live Target]1=<7, "1 Week",…
-
Is there an alternative for WORKDAY.INTL in Smartsheets?
Hi, I have a formula on excel that uses WORKDAY.INTL and it doesn't work in Smartsheets. I have made the formula so it only produces dates that are on a Tuesday, Wednesday and a Thursday. Is there another way to do this? Thanks, Liam
-
Hyperlink Formula to Display Text or Image
I have a link being generated based on the information from multiple cells within each row on SS. I would like to have that link embedded into an image, so when a user clicks the image, it takes them to this row specific link. Is SS planning on adding the hyperlinks formula ['=HYPERLINK([cell containing generated link],…
-
Link to Parent on the same sheet
I've got this formula that returns the Name of the Parent =PARENT([Name of Request]@row) But, I'd like to add a link to the parent rather than simply return the Name of the parent My use case is Tasks (Parents) and SubTasks (children) In card view, on the Child, I need to add a link to the Parent as the children will be…
-
Auto number
I have a spreadsheet where i keep track of all the samples that we've sent for laboratory testing. They all have a despatch date and the lab that they are being sent to. Is it possible to set up the Auto-number system to generate only one number for all the rows with the same lab and date? The goal for this is to create…
-
Vlookup using Dates
Hello, I'm having some issues around a simple vlookup using dates. I have include screenshots to assist. My formula looks as follows and I am getting a "invalid data type" error. =VLOOKUP([Batch Helper]1, {Site Disposition - database (MASTER) Range 2}, {Site Disposition - database MASTER Range 1}, false) I am trying to do…
-
Automate Duration Column in Gantt Chart
I'm trying to Great a semi automated Gantt which sets an automatic duration of a task based on Hours, Variance and allotted staff. When task dependencies are on i appear to not be able to write a Formula into this cell. is there a way around this aside from manually doing the maths on the hours every time?
-
Simplify this formula to enter quarters based on date range.
Hello, I need help simplifying this formula. I need to enter a Quarter based on a date, For example, if the date is Jan 1 2020, enter Q120 in the cell. If April 1 2020 than enter Q220, and so on. I am using this formula, which is making the sheet to complicated and possibly impacting the performance. The crazy formula is:…