-
Date Created System Columns
Hello! I'm in need of some help with something that seems so simple but I'm going in circles. I was using a form / sheet to track responses for a program that runs quarterly. Standing up a new form / sheet quarterly was becoming an issue so we moved to a database format - ie. every response on one form / sheet regardless…
-
Can my contacts be updated by my company AD (eg. contacts in our Outlook Address book)?
I want My Contacts to be up to date with my company address book. Is this possible?
-
Display text in a countif formula
I have a project type column and I want to show in the summary row at the top of my sheet the number of PoCs and Pilots. Instead of just displaying the number, I want the cell to read PoCs = 22 or Pilots = 15 =(COUNTIF([Project Type]3:[Project Type]69, ="PoC"))
-
Multiple conditions (from different columns) applying conditional formatting
1 Can I do conditional formating using more than one criteria (different Columns) We track goals for residents and if the goal is not met within the required timeline I would like it to highlight the total in red. is there a way to make 2 conditions for the same formatting rule? example if frequency is '30X/Month' and…
-
IF Formula with Children
Hi everyone, I am new to Smartsheet so apologies if this has been answered elsewhere. I am trying to change RYG balls for a parent row based on children rows being marked done or not. I've used this formula which seems to work, but it gets tedious when there are several Child rows to include or if I want to add another…
-
I would like a formula to tell me the number of days holiday taken this month
I have searched for a formula to calculate the number of days holiday, but I would like it to be more specific to tell me the number of days taken this month. So far I have this: =SUMIFS(Duration:Duration, Absence:Absence, "holiday", Assigned:Assigned, "Fred") which tells me the number of days holiday, total. But I need to…
-
Smartsheet Cell Created
Can anyone figure out why this is happening? I have the date cell with =[Date4/7/20]@row but it's showing it as a different date. I cannot figure out a work around this bc using countifs to count today's date . So cant use =LEFT function.
-
Can i have the AVG(collect) formula in the same column as the range that I want to Average?
I want to average the % complete column. I am writing the formula i the top row of this column and it doesn't allow me to do it. also, doesn't allow me to select any column from the same sheet. Am I missing something here? How can I solve this?
-
Calculation of monthly duration
Hi All, I've been trying to find a formula to automatically calculate duration in months from start date and end date. I went through several threads here but none of them seems to fit at all. Could any of you advise? I presume it is something in terms of =[End Date]@row - [Start Date]@row, unfortunately this shows me…
-
Using the v-look up function
Hello, I am trying to use this formula, =VLOOKUP([Facility ID]1, {Data Control Range 1}, 3, false) and it continues to come up no match or incorrect argument set, is there anyone able to help figure out whats going on here?
